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 ?
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?
