Pivottables update source data incorrectly



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.



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