M
mofojed
If you download an excel spreadsheet with a pivottable whose source data is
in the same workbook from a website, and select "Open" (rather than "Save"),
you will not be able to refresh the pivottables. This is because it
automatically updates the source data information to the temporary file in
your cache that no longer exists (I think). In any case, the error it throws
either should not happen (since the pivottable should not update the source
data for something in the same workbook), or it should tell the user to
download the sheet before refreshing pivot table data.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5386e42&dg=microsoft.public.excel.crashesgpfs
in the same workbook from a website, and select "Open" (rather than "Save"),
you will not be able to refresh the pivottables. This is because it
automatically updates the source data information to the temporary file in
your cache that no longer exists (I think). In any case, the error it throws
either should not happen (since the pivottable should not update the source
data for something in the same workbook), or it should tell the user to
download the sheet before refreshing pivot table data.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5386e42&dg=microsoft.public.excel.crashesgpfs