Ref # 644
Problem:
When I press F5 to refresh my displayed chart, or if the chart refreshes automatically every N seconds, the "refreshed" chart doesn't show any newly added data.
Solution:
Microsoft Access Data Source
If Microsoft Access is being used to add new data to the Access database then ensure that the database is not opened by Microsoft Access in exclusive mode. When Microsoft Access opens the database if the Exclusive box is checked then CHARTrunner is not able to see the newly added data.
Microsoft Excel Data Source
See the KnowledgeBase article here for more information about concurrently adding data to an Excel workbook while charting that workbook with CHARTrunner.
Close Data Source After Drawing Chart
Although CHARTrunner opens all data sources for read-only access some data sources may lock in a manner that prevents other users from opening the data source once CHARTrunner has displayed the chart. CHARTrunner version 1.1.183 or higher allows CHARTrunner to close the data source after the chart has been drawn and thus circumvent this problem. Later versions of CHARTrunner by default create new chart definitions with the Close data source after drawing chart option enabled. When this option is enabled CHARTrunner will open the data source only long enough to get the chart data and will then close the connection to the data source.
To enable this option:
- Modify the chart definition.
- Click on the Misc tab.
- Click on the Close data source after drawing chart option so that the checkbox is checked.
- Click on OK to save the change.
