Good afternoon,

My question is a bit hard to explain.. but I will do my best to convey
it.

I have two spreadsheets in an Excel file. In the first sheet I have
"raw data" (hereon called RawData). The second sheet (hereon called
DisplayData) contains basic formulas that just pull the data from
RawData, and arranges them in the way I want them displayed (ultimately
for printing). This excel spreadsheet will be used by laymen who don't
have time (or the understanding) to fool with layouts for their data.
So I am trying to take data, and arrange it into a easily updatable
document. All they will need to do is update the data in RawData, and
DisplayData will reflect the changes for printing. Basically I'm trying
to reduce the redundancies that they've already created.

Creating the links between the two sheets are easy, just hit "=" and
point it to the sheet, then the cell. I set the formula to not change
by using the string prefix before the row and the cell number. (I.e.
='Raw Data'!$E$2). Thats not a problem, I can do THAT much. :)

The problem is occuring when I insert a row on RawData. It does not
reflect that change on DisplayData. Instead it tries to act "smart" and
updates all of the formulas in DisplayData to make sure that it retains
the correct data and layout (i.e. ='Raw Data'!$E$2 becomes ='Raw
Data'!$E$3 when I want it to stay the same). Well I don't WANT it to
retain the look. When I insert a row in RawData, I want DisplayData to
reflect that, and bump all the data down one row.

How can I stop this "smart" updating from happening? Or is
it not possible? I've heard that this is not possible.

Thanks ahead of time for any advice!

-Chris B


--
FatMagic
------------------------------------------------------------------------
FatMagic's Profile: http://www.excelforum.com/member.php...o&userid=10701
View this thread: http://www.excelforum.com/showthread...hreadid=476270