L
Loopi
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
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