I have a workbook with a pivot table which is based on an Access table. I was under the impression that once you refresh the pivot table, excel would store the necessary data internally. I e-mailed my workbook to my home from the office and when I opened it, there was no longer a pivot table. It had just been converted to text and numbers.
How can I make a workbook with a pivot table portable so that I can send it to people who don't have access to the original MS Access database (short of actually pasting the data into Excel itself - the file would be too large)?
How can I make a workbook with a pivot table portable so that I can send it to people who don't have access to the original MS Access database (short of actually pasting the data into Excel itself - the file would be too large)?