Forum Discussion
Data disappears from worksheets.
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 ?
Panas_Wiwat-1964 Opened your file on an older MB Air (Big Sur, MS365 subscription, beta) The first few seconds the screen was white, then it opened properly. Although, it is "beach balling" (i.e. updating very slow) whenever I change something or switch to another sheet. But that's probably due my MB and the size of your file. Nothing disappears, though. See picture. Which Mac-OS are you on? Which Excel version?
The data on the master sheet is fine, but the problems are in the daily sale & ad expense and the monthly sales sheet. When I first open the file, all the data was there, but as soon as I put data in the master sheet, the summarized data from day 12 in the daily sales report sheet disappeared. Very frustrated cause I need that data for our next sales meeting this Saturday.
Panas_Wiwat-1964 I see. Tested your sheet again and noticed that the sheet doesn't calculate automatically, even when "auto calculation" is switched on. Copied all formulae from row 12 down and everything calculates instantly. Saved the file, closed it and reopened it. Now, when I add a row with data, the sheet calculates properly. Can't really explain why this happens, but I notice that your sheet has serious performance problems. But that's perhaps only an issue on less powerful systems (like my MB Air). And just trying to "play-around" with all the conditional formats hangs-up my Excel instantly.
Perhaps you need to consider collecting your transactional data without too much fancy formatting and use Pivot Tables to summarise it. You can achieve more-or-less the same results, cutting down on the file size and number of calculations and increasing performance considerably.
How do I do that? A friend of mine created the whole worksheet for me. I know nothing about creating conditional formatting.
PanasW56 Perhaps you can ask your friend to help you again to "clean-up" your sheets. But, I understand that removing the CF did speed up the sheet, but did not resolve the problem.
Attached workbook contains your data without formatting and two pivot tables to demonstrate what is possible. And this is just a very simple example.
