Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
proquant
 
Posts: n/a
Default Excel 2002 chart does not update when worksheet data changes

I am using a large Excel 2002 workbook (circa 50k rows). When the worksheet
data is changed, the associated chart fails to update with the new data.
Instead, I have to manually make a change in the Source Data Range section of
the chart (any change will seemingly do - e.g deleting a number and retyping
it). This seems to re-establish the link with the worksheet data, and the
chart then updates. However, if the worksheet data is subsequently changed
again, the problem re-occurs.

The Charts were created using the normal Chart Wizard by highlighting the
relevant cell ranges. The ranges were not typed as I know that this can cause
updating problems.
While the workbook is large, the chart range only covers about 1000 rows.

I would appreciate any help in solving this problem.


  #2   Report Post  
Junior Member
 
Posts: 1
Default

I am having this same problem, and wondered if anyone has figured it out.

Quote:
Originally Posted by proquant
I am using a large Excel 2002 workbook (circa 50k rows). When the worksheet
data is changed, the associated chart fails to update with the new data.
Instead, I have to manually make a change in the Source Data Range section of
the chart (any change will seemingly do - e.g deleting a number and retyping
it). This seems to re-establish the link with the worksheet data, and the
chart then updates. However, if the worksheet data is subsequently changed
again, the problem re-occurs.

The Charts were created using the normal Chart Wizard by highlighting the
relevant cell ranges. The ranges were not typed as I know that this can cause
updating problems.
While the workbook is large, the chart range only covers about 1000 rows.

I would appreciate any help in solving this problem.
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
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 cagedbirdflies Excel Discussion (Misc queries) 0 February 21st 05 09:13 PM
password issues in Excel 2002 Stephen Larivee Excel Discussion (Misc queries) 7 February 18th 05 11:58 PM
How To Refresh Chart Data Without Calculating The Worksheet Carl Bowman Charts and Charting in Excel 5 January 19th 05 10:28 PM
Adding a chart to a Word template linked to an Excel doc. Bobbie Excel Discussion (Misc queries) 0 January 3rd 05 09:07 PM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 08:12 PM


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