Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Saving file changes relative to absolute

I have a simple spreadsheet with relative addresses but when I exit the file and re-enter it the addresses are changed to absolute addresses (ie with $ in front of the address). It doesn't happen when I save the file only when I come out of it and go back in again. How can I stop this from happening?

eg A1+B1 becomes $A1+$B1 which I don't want to happen.

click to hide/show revision 2
retagged

Saving file changes relative to absolute

I have a simple spreadsheet with relative addresses but when I exit the file and re-enter it the addresses are changed to absolute addresses (ie with $ in front of the address). It doesn't happen when I save the file only when I come out of it and go back in again. How can I stop this from happening?

eg A1+B1 becomes $A1+$B1 which I don't want to happen.

Saving file changes relative to absolute

I have a simple spreadsheet with relative addresses but when I exit the file and re-enter it the addresses are changed to absolute addresses (ie with $ in front of the address). It doesn't happen when I save the file only when I come out of it and go back in again. How can I stop this from happening?

eg A1+B1 becomes $A1+$B1 which I don't want to happen.