WHAT COULD CAUSE #Ref error ON UNLINKED SHEETS

C

CAPTGNVR

DEAR ALL
I HAVE A FILE BY NAME SAY CARGO.XLS. In this file there are 20
sheets. In VB i transfer the say three sheets from the cargo.xls file
for transmitting from the cargo control to the radio room.
What i cant figure out is if I open one sheet and then the other some
of the cells get # ref error.
For your information-- I do not have any links in the cells showing
this error. The formulas in these sheets are referring to the sheet
cells itself. What could be the cause. Pls advice.
 
J

Jon Peltier

If your formulas refer to a cell in column A, and you delete column A, the
reference to the cell is changed to #REF!

- Jon
 
C

CAPTGNVR

If your formulas refer to a cell in column A, and you delete column A, the
reference to the cell is changed to #REF!

- Jon
Click to expand...

D/PETER, thnks ur response. In radio room i open the first sheet
exported and it is fine. I open the second sheet and it is also
fine. When i go back to the first sheet then it shows these ref
errors in cells. All these days i did not face this and unable to
ustand the reason for this.
 
Top