Forum Discussion
Solved
Data disappears from worksheets.
My excel sheet is acting weird. I have multiple sheets linked together to perform sales and expenses analysis it all works out find when I open the file but once I enter a data on one of your worksh...
Some of the cells on the Master sheet contain circular references: A3581 to A3589, and A3613/A3617.
Does the problem persist if you correct these by double-clicking the fill handle in A3, or by changing the formula in A2:A3925 to =ROW()-1 ?
It appears there are over 41k conditional formats on the master sheet?
While googling to see what excel's conditional format limits are, I happened across this post in which a person experienced problems w/ the application freezing/crashing when testing with large numbers of format conditions.
I deleted the format conditions in the attached file. Perhaps try opening the file and test to see if it runs any better?
