Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GHawkins
 
Posts: n/a
Default Unable to break links

I am using Excel 2003 SP2. I have a workbook that contains links to 7
different spreadsheets. I want to send the workbook to others, but want to
break the links so that they see the actual values I am sending, not the
linked value in case that would change in the meantime. I have done this
before - I go to Edit, Links, and then highlight the links and select "Break
Link". However, when I do this only one of my sources is removed - the other
6 are still listed, and the formulas linking to the workbooks still exist.
All of the workbooks sit in the same folder on the server. What am I doing
wrong?
Reply
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
Hyperlinks - Move file to local drive, all links break Shawn McGowen Excel Discussion (Misc queries) 1 March 9th 06 12:52 AM
links in cells break and revert to user profile location heathy Excel Discussion (Misc queries) 0 October 24th 05 05:37 PM
How do I break links in a workbook? Alwebster6635 Excel Worksheet Functions 3 July 21st 05 07:26 PM
Want Excel to break links between worksheets in same file eclectic_kx Excel Worksheet Functions 1 May 25th 05 06:38 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 05:47 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"