List: Assume I have two sheets - call them "master" and "lookup".
I use the values in the sheet "lookup" for calculations inside the sheet "master". For instance, let us assume that I have a cell, say, A1 in master that does a HLOOKUP() on a range of cells in the sheet "lookup". This works fine. When I copy the sheet "master" (by right clicking on the tab, selecting copy/move with a check mark on "copy") to another sheet (say, "junk"), then, the references that I have (in the cell A1 of master to the hlookup in "lookup") get changed to the sheet "master". To wit: Sheet master: cell A1 contains : hlookup(a2; lookup.a2:b10; 2; "false") Sheet junk : cell A1 contains : hlookup(a2; master.a2:b10;2; "false") Is there any way to tell Calc NOT to change references ? Or am I missing something ? Any help would be appreciated, and taken gratefully. Thanks Pradeep Srinivas Bangalore, India. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
