|
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 |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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].
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:
|
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 |
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 |