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 ?
Here is the file after I followed your instructions. Still has the same problem. My friend tried opening it on a Window machine and it seems to have worked and sent the saved version to me. It worked when I opened it but as soon as I did something the master sheet, all the data in other worksheet disappeared.
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.
