I have a quite complex spreadsheet. About half the time, when I change a
cell, I get several hundred Err: 522 cells. This will happen even when
the cell I change is referenced by no other cell.
I can get rid of all the Err:522 entries by CNTL:SHIFT:F9 or by double
clicking on the column
Hi :)
If it's not hugely heavy and doesn't have confidential stuff such as names
and addresses or super-secret financial info then how about just uploading
it to Nabble and let us have a look?
It sounds to me like there is a circular reference buried somewhere in the
sheet but somehow you are