Keeping an absolute reference in a cell

		Microsoft Office Forums > Microsoft Excel > Excel
Keeping an absolute reference in a cell

FAQ

Thread Tools

Display Modes

01-08-2014, 11:06 AM

bremen22

Windows 7 64bit Keeping an absolute reference in a cell

Office 2010 64bit

Advanced Beginner

Join Date: Jul 2013

Posts: 44

Keeping an absolute reference in a cell

I have a sheet where a third of the data provided is from an Oracle, another third pulled from another sheet, and the rest are calculations based on the previous.

I am having an issue with one column in particular that s pulling data from another sheet. My Formula reads

Code:

='Current Status'!$G$2

with the cell reference changing accordingly. When the table is refreshed it reverts back to the original formula and all cell references are lost.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:24 PM.