LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Posts: n/a
Default Excel hyperlinks to other cells in workbook must be relative

I've created an Excel spreadsheet with a few hundred hyperlinks to other
cells, spending hours fixing references because they're all !absolute. Now I
find I've left out two columns in different places. If I insert the columns,
the hyperlinks refer to the wrong cell. Is there a way to to fix the
references, such as copy from destination cells (about 33 cells) and paste
hyperlinks into destination cells so the references carry over for all the
Now, if I select a column of cells and copy, then select the matching
destination and select edit/Paste hyperlink, it still only pastes the
destination of the top cell, and the reference is !absolute.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
custom color palette does not get transferred with the workbook. Excel 2003 libra2222 Excel Discussion (Misc queries) 3 December 2nd 05 01:02 AM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
Problem sorting cells containing hyperlinks cottonchipper Excel Worksheet Functions 1 November 5th 05 03:08 PM
How to refresh a Excel workbook with pivot & ADO query report in batch mode Karen Middleton Excel Discussion (Misc queries) 1 April 29th 05 02:05 PM
How do I change an Excel range of cells from relative to absolute. Jrhenk Excel Worksheet Functions 2 November 15th 04 10:55 PM

All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"