Keep MS Excel From Automatically Updating Charts
- by Carol Bratt on 20070813 @ 12:29AM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: link, break, chart data, capture screenshot, copy)
Sometimes it seems as though Microsoft Excel is almost too efficient. For instance, Excel will automatically update a chart when you make a change to the chart data.
If you need to capture a screenshot of your chart before a change is made, you need to break the link to its data source.
Follow the steps below to prevent MS Excel from automatically updating your charts:
To keep Excel from automatically updating a copy of a chart with new data, you need to break the link to the source data.
- Launch MS Excel if it isn't already open.
- Copy the chart that you do not want to be automatically updated to another workbook.
- In the second workbook, go to Edit | Links.
- Click the link between the chart and its data source.
- Click the Break Link button.
- In the error warning box, click the Break Links button, and then click Close.
You can now capture a screenshot of your chart data before the chart is updated.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
