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 ?
I cannot reproduce the problem, but like your friend I'm on Windows.
Are you on MacOS? If so, I hope that someone with Excel for Mac can look at it.
Thanks, I hope so too. It's very frustrating. Was the problem not there in Windows?
No, I didn't notice a problem when editing the Master sheet. The data that were present on the other sheets before were still there.
Maybe it's a Mac specific problem. I am using Mac 10.15.7 and excel for Mac version 16.44
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.
