Broken link between pivot table and data

Question

Excel 2007 on Windows XP Large data set 182 columns by 2009 rows Pivot table has worked for past year using table name reference (Table1). Today, began getting "invalid reference" error when attempting a refresh to pick up newly added data into the source workbook/sheet. Initially changed the table name to begin/end cell references and would still getteh message but PT was updated from source. Change the reference back to Table name and would not update? Is there a limit to number of cells that can be manipulated? we are approaching 400,000( 365,658) Problems with worksheet names-- source is, and has been for whole year, named DOR RAW DATA, yes it has two spaces in it. That was my first thought, however it worked up until now. Does Excel have a path name length limit? We are currently at approximate 150 characters.

Answer 1

Refer to the link below information about Excel specifications and limits.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

You may want to check the ‘cause’ section in the article KB 213983 for information about the limitation of characters for file path.