I have been wrestling with this for over 2 weeks.
I have a spreadsheet with a simple LIST.
In the last 12 columns are months... Jan, Feb etc... the same formula auto calculates through out that range.
Even if I change the formula to something simple like =$D4.... when I save, close, and then reopen the workbook and then add a NEW ROW ... I get #VALUE! throughout the range.
I have destroyed the list and recreated it... no help.
I have added the simplest of formulas.... no help.
I have deleted the two PivotTables... no help.
I have deleted the existing graph that was based on a PT... no help.
I have run out of ideas.... What causes this weirdness?
Bookmarks