Excel 2013 Refreshall then save does not save changes

[mbakanec]

I have several spreadsheets that are on a SharePoint site that contain connections to a SharePoint list. Each sheet contains multiple connections. I need to automate the process to open each spreadsheet, perform a RefreshAll then save the spreadsheet. The VBA code works perfectly if I step through it using F8 but if I let it run it appears to go through the refresh (I see the messages showing the connections), it saves the file but the saved file does not contain the refreshed data. I added an Application.Wait in case the refresh was not complete but that did not help. I have searched for similar issues but did not find anything. Any help would be appreciated.

Please Login or Register  to view this content.

[JBeaucaire]

Try adding a DoEvents after the RefreshAll.

[mbakanec]

Thank you for the suggestion but that did not work. I tried before and after the Application.Wait and I tried taking the Application.Wait away and the saved file does not contain the updated information.

[mbakanec]

I increased the wait time to 2 minutes and it seems to be working now. Thanks for your assistance.

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

[mbakanec]

Thank you! I could not find the way to mark it solved.