LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Gordon
 
Posts: n/a
Default

ADC wrote:
Thanks for your feedback. This is what I assumed was causing the problem.

I have tried various other alternatives. The worksheet is a highly formatted
summary of data calculated on other sheets within the workbook. I tried
copying the sheet to a new workbook by right clicking the tab and clicking on
Create a Copy. The problem is it creates a new workbook linked back to the
original.


Once you have made a copy of the sheet, select the whole sheet and do a
Copy-Paste special-values. That will get rid of the links.



--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(9 days and counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!
 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM
Opening Excel after changing settings and add-ins swesterm Excel Discussion (Misc queries) 3 December 29th 04 06:54 PM
Excel page settings Rafi Excel Discussion (Misc queries) 3 December 15th 04 10:07 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 12:33 AM.

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

About Us

"It's about Microsoft Excel"