Hello:
I know you are all thinking "Excel isn't crazy, it must be user error", I hope you are right
I have a self created home budget in excel that worked fine. I open the file, everything appears to be working fine until I enter any data on one sheet. Then everything stops calculating (even the cells that were working fine when I opened the file).
- When I undo the data I entered, it will still not calculate older data (which was calculated when the sheet was opened) and remains blank.
- I have replaced the data sheet with a copy, and it still will not cause the cells to recalculate (as they did when the file is opened).
- Even adding a new row to the sheet will cause everything to uncalculate. Removing this row does not cause the file to revert back
- Only changes to columns A,B,C,D seem to be affected. I can edit the other columns without the other sheets going blank
The excel file has about 6 sheets, 5 of which take information from 1 sheet (named 'Data') and calculate it.
Example:
FLOP, Revenue, Expenses, Assets, Liabilities, Data
It is when I change, or type anything on the 'Data' sheet (columns A,B,C,D) the other sheets calculate nothing. Any ideas? :S
Here is a copy of the file if you want to see for yourself. I only have one months worth of data on it (sorry my personal finance numbers are not impressive I will be trying it on my wives computer to see if it is just me.
Personal Books 2014(copy).xlsx
Bookmarks