#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default Copying sheets

I'm tring to copy a sheet to a new workbook. The formulas are all linking
back to the original workbook. This only seems to happen with this one sheet.
Is there a setting a may have checked off?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 342
Default Copying sheets

I don't think it is anything you checked. I think that any references to
other worksheets will refer back to the original workbook. You can convert
all of those links to values with <Edit<Links<BreakLinks.

Hope that helps.

Tom

"j.ruderman" wrote:

I'm tring to copy a sheet to a new workbook. The formulas are all linking
back to the original workbook. This only seems to happen with this one sheet.
Is there a setting a may have checked off?

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
Copying Sheets LiAD Excel Worksheet Functions 1 September 10th 08 04:55 PM
copying macros to other sheets esilverb Excel Discussion (Misc queries) 3 June 25th 08 11:16 PM
Copying Sheets Ross Excel Discussion (Misc queries) 1 January 2nd 08 07:02 PM
copying sheets fastballfreddy Excel Discussion (Misc queries) 2 May 5th 06 07:20 AM
copying text across sheets nospam Excel Worksheet Functions 1 July 26th 05 07:05 PM


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

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"