I have a very big file (23MB) that has always worked fine until recently when I added some more columns. The file size increased by about 2MB and now it refuses to calculate.
The file is full of vlookup() and Index() functions but they have always seemed to work in the past with no problem.
I always keep my files on autocalc and even with autocalc I still have the calculate signal in the bottom left. Now it appears everything is calculating correctly with the exception of the charts which won't update...
I contacted Microsoft and even sent them the file but they haven't been able to figure it out (cost me $35).
The guys at Microsoft said it wasn't a problem but I read about a limit on dependent cells, how do you check the number of dependent cells you have in a workbook?
Does anyone know what would cause this to happen? Vlookups? Index? File too large? (although I have a co-worker with a 45mb file that works fine)
Any help would be appreciated.
The file is full of vlookup() and Index() functions but they have always seemed to work in the past with no problem.
I always keep my files on autocalc and even with autocalc I still have the calculate signal in the bottom left. Now it appears everything is calculating correctly with the exception of the charts which won't update...
I contacted Microsoft and even sent them the file but they haven't been able to figure it out (cost me $35).
The guys at Microsoft said it wasn't a problem but I read about a limit on dependent cells, how do you check the number of dependent cells you have in a workbook?
Does anyone know what would cause this to happen? Vlookups? Index? File too large? (although I have a co-worker with a 45mb file that works fine)
Any help would be appreciated.