Keeping an absolute reference in a cell

BobBridges · #4 01-14-2014, 10:33 AM

Ok, I'm not with you yet but I'm making progress. I'll describe what I understand so far and you correct me:

In the History worksheet is a column that pulls data from another worksheet named Current Status. The formula for pulling that data is simple:

Code:

='Current Status'!$E$2
='Current Status'!$F$2
='Current Status'!$E$3
='Current Status'!$F$3
='Current Status'!$E$4
='Current Status'!$F$4
='Current Status'!$E$5
='Current Status'!$F$5

...and so on.

But elsewhere on the History worksheet is a table that is populated from an Oracle query. Every time the workbook is opened the Oracle query is refreshed, which is as it should be — but when that happens, this column is changed, too, which shouldn't happen; every value is changed to "='Current Status'!$G$2". Your question is why the Oracle query is refreshing not just the proper range in the History worksheet, but also this column (and why just in that way). Right so far?

Actually, I'm pretty sure I'm wrong. Maybe the part that's getting updated is in the Oracle query's range. Or maybe not every formula in this column is being changed back to $G$2. Tell me what I have wrong and maybe we'll be ready to proceed from there.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to reference a cell value	Jmoney2290	Excel	1	11-06-2013 09:39 PM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM
How do I align image at ABSOLUTE top left of a table cell?	shnoozin	Outlook	0	07-22-2011 03:30 PM
How To Get Image to be absolute center of slide	mjg060468	PowerPoint	3	08-09-2010 02:07 PM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM