Stream XLS to Excel XP

V

Vlad S

I have Excel document containing PivotTable on the Sheet1 and source dtata
for it on Sheet2. PivotTable options set to refresh data on document open
event. Data table on Sheet2 populated dynamically on the web server and then
document streamed to user with content type set to open it in browser. It
works fine with Excel 97/2000. With Excel XP i am getting error : Can not
read data from 'GenerateReport.asp?FundID=1'Sheet2. When user choose to save
file on the local drive and open in Excel - works without error.

Any ideas?

Vlad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top