Microsoft Office Forums

Go Back   Microsoft Office Forums > >

View Poll Results: Was this post useful at all?
Yes 0 0%
Somewhat 0 0%
Not what I was looking for 0 0%
Not at all 0 0%
Multiple Choice Poll. Voters: 0. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2010, 01:30 PM
omirza omirza is offline Strange errors Windows 7 Strange errors Office 2007
Novice
Strange errors
 
Join Date: Feb 2010
Posts: 1
omirza is on a distinguished road
Default Strange errors

I am exporting content of a grid in my application through a function provided by that grid which ouputs in xml. I send that data to server and the from server I change the response as:




Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "filename=Report.xls;attachment");

This gives user an option to either open excel file directly or save it. If user opens it directly, without saving the file first. Excel opens up with a message:
"The file you are trying to open, 'Report[1].xls', is in different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
options provided by message box: [Yes] | [No] | [Help].
  • Why does excel think that format is not right, where, if I open file after saving it, I don't see this error?
After I click on [Yes] button in message box, file opens up fine, headers with filter options.
Now, if I try to insert "Pivot" on this spread sheet. By selecting few cells and rows with/without headers and then selecting "Insert"->"Pivot" as soon I press [Ok] on Dialogbox to confrim my Pivoting, I see this error:
"Datasource reference is not valid", but If I save this file on desktop and reopen it then pivoting works all fine:
  • Any clue what would cause this error?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
strange png attachment laura Office 0 10-15-2009 09:24 AM
Strange errors Encryption XOR - any errors??? Word Doc Word 1 10-08-2009 12:57 AM
COM Automation Errors ivanm Word 0 03-23-2009 07:02 PM
How do you fix ost in use errors? enviroko Outlook 0 10-23-2008 09:49 AM
Please help with a strange issue... LeaderLG Outlook 0 08-22-2008 05:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft