Help Please
Office 2007 all updates
Continuous looping PowerPoint displaying charts that are linked to an excel
workbook which remains open at all times.
PowerPoint has an add-in to update external links each time the continuous
presentation loops (triggered after last slide is displayed)
Linked excel workbook remains open at all times. This workbook has a timed
macro that retrieves data from other workbook sources on an hourly basis.
Code: (ActiveWorkbook.UpdateLink Name:= _ "K:\ Daily Production Sheets\1008
Production Reports.xlsb", _ Type:=xlExcelLinks)
This process works great for two and three days at a time then out of
nowhere the updating stops and the excel workbook displays this error “this
workbook contains one or more links that cannot be updated 101120” I have run
the bad link finding add-in that prior efforts revealed but no bad links were
discovered. I can manually run the macro and no errors occur. My frustration
is that it will work fine for a while then blow up and there is no pattern or
indication that it is imminent. Is it possible that if a user had the
workbook open that the primary workbook is linking to that this could blow
things up? If so how could I protect the process from crashing? This would be
bad because by nature it will have to occur frequently. I am not a VB guru so
please be kind in your responses.
Thank you for any suggestions
|
Similar Threads
