Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.
I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there [...]

Answer Question   |  November 8, 2010  7:41 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Pivot Table Refresh, Pivot tables