Keeping an absolute reference in a cell

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:29 AM.