On Sun March 30 2008 14:21:54 V S Pradeep wrote: > 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 ?
My apologies for answering my own question. I fiddled around some, and found out that if I used a "$Sheet_Name" instead of a "Sheet_Name" in the reference, then, Calc would not change the reference. That sorted my problem out. Once again, my apologies. Pradeep --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
