Posted to microsoft.public.excel.worksheet.functions

Mike K

external usenet poster

Posts: 104

Absolute cell reference will not remain absolute.

Oh Wise Ones,

Excel 2003 SP
WinXP Pro

I have a date in J4. If I link the contents of J4 to another
workbook by using ***$J$4 and I insert a row where the date in J4 may change,
my linked cell reference is now to $J$5. Why does this happen?

Thanks,
Mike

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
absolute cell reference macro	rk0909	Excel Discussion (Misc queries)	4	November 7th 09 12:37 AM
Absolute Cell Reference Click	Jeremy	Excel Discussion (Misc queries)	3	February 11th 08 09:09 PM
Reference absolute cell values	[email protected]	Excel Worksheet Functions	3	February 11th 08 07:48 PM
Absolute Cell Reference	Joshua K Briley	Excel Discussion (Misc queries)	5	December 27th 05 06:32 PM
Absolute cell reference question	Dick L	Excel Worksheet Functions	1	September 22nd 05 01:33 AM

All times are GMT +1. The time now is 11:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us