View Single Post
 
Old 10-04-2020, 09:22 AM
nadavsn nadavsn is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2019
Posts: 3
nadavsn is on a distinguished road
Default VBA updating ChartData allocated memory

Hi
I am using VBA code to update ChartData from a DB with the command:
shp.Chart.ChartData.Workbook.Worksheets("Sheet1"). Range(columnName & 1).Value =...

the only problem is that the PowerPoint keeps an open Excel session on the RAM even after I finished to update the chart.
with many slides, it became a huge load on the PC.
is there a way I can free the workbook from the RAM after I finished update it?
thanks!
Nadav
Reply With Quote