Data Table with External Links

jazminet

Guest

Posts: n/a

24th Mar 2004

I created a series of charts using links to an external
workbook. When both workbooks are open, the charts look
exactly the way I want. When the source workbook is
closed, the data table in the destination workbook
changes.
The numbers that are supposed to show a percentage, show
up as a general number instead. There's a lot of support
written on how to change the data labels with external
links, but nothing written on updating the DATA TABLE.
How do I change the number format in the DATA TABLE?

« Charting DBF files in Excel using VBA? | Recent Microsoft Excel Updates - March 24, 2004 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove links to external data	=?Utf-8?B?Um9uIERyZXhsZXI=?=	Microsoft Excel Misc	0	5th Oct 2007 03:21 PM
catalog external links and list all pivot table sources	=?Utf-8?B?RGF2ZSBG?=	Microsoft Excel Misc	0	15th Mar 2007 06:11 PM
Preserve existing data whilw using external links	=?Utf-8?B?SGFs?=	Microsoft Excel Worksheet Functions	0	7th Apr 2006 01:38 AM
Design a table to include external file links	=?Utf-8?B?U3BlbmNl?=	Microsoft Access Database Table Design	3	10th Feb 2005 05:22 PM
breaking / removing links to external data source	Tracy	Microsoft Excel Worksheet Functions	3	3rd Mar 2004 08:23 PM