When Excel pulls data from an external source (e.g. - for a pivot table), is the source data ever stored locally?
-
I have a pivot table that sources data from a remote server. I have since lost access to the data/server. The spreadsheet is abnormally large for its contents so I am wondering (and hoping) if the original data is stored within the file before being filtered and populated in the table. If so, is it possible to retrieve the data? Thanks for any guidance.
-
Answer:
When you connect to an external data source and use PivotTables, Excel will populate the PivotCache an internal data structure we use to store all the data that you retrieved with that connection. By clearing all the filters from your PivotTable you should get all the data that was initially retrieved. Note: This does not work for OLAP PivotTables (connected to a multidimensional data source) or the new style data Model PivotTables introduced with Excel 2013.
Diego M. Oppenheimer at Quora Visit the source
Related Q & A:
- Why does e.g. Hubble's secondary mirror not block part of the picture?Best solution by Astronomy
- What is Hash Table, how to create a hash table?Best solution by Stack Overflow
- How to find the embed code for videos on a Website when it doesn't show in the source code?Best solution by Stack Overflow
- How can I extract data of an external XML to PHP?Best solution by Stack Overflow
- Do you think dreams are a message from some higher source?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.