LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Graph links to copied sheet

Hi

I have noticed a difference between Office 2003 and 2007. In 2007 when you
copy a sheet with graphs in it, the new sheet keeps the links to the table in
the original sheet not the copied one. So when you input new values on the
new table the graph does not show them, but the old ones. Does anyone know
how to change settings so the new graph has the links to the new table/sheet?

Many thanks

PS Also, anyone knows how to eliminate some sections of the ribbons?
 
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
Copied Graph changes values Keith H[_2_] Charts and Charting in Excel 0 February 9th 09 12:38 PM
how to unlink links copied from a list from the internet kmjmail Excel Discussion (Misc queries) 2 January 3rd 09 06:22 AM
Word O7 looses links with excel 07 when files copied to network fr Brian Links and Linking in Excel 1 November 28th 08 11:15 AM
Bug: Move or Copy sheet graph links not updating! Alice Excel Discussion (Misc queries) 4 May 2nd 07 01:37 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


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