Hello,
I have created several spreadsheets using PowerPivot. These sheets are being used by many people in the company I'm working in to access information. Since some of the users do no have a lot of excel skills I have created Refresh macro buttons on each spreadsheet to update the PowerPivot pivot tables. I have used the code from the following website: Automating PowerPivot Refresh operation from VBA | Tom Gleeson - Power Pivot and Excel Consultant. Lately the users of the reports are getting errors saying the database can not be located. With some investigation it looks as though the macro is looking for a connection that no longer exists and needs to find a new connection. Does anyone know of changes to the code to get rid of this error. OR more preferably a way to refresh the PowerPivot data within the excel spreadsheet?
Any help is greatly appreciated!
I have created several spreadsheets using PowerPivot. These sheets are being used by many people in the company I'm working in to access information. Since some of the users do no have a lot of excel skills I have created Refresh macro buttons on each spreadsheet to update the PowerPivot pivot tables. I have used the code from the following website: Automating PowerPivot Refresh operation from VBA | Tom Gleeson - Power Pivot and Excel Consultant. Lately the users of the reports are getting errors saying the database can not be located. With some investigation it looks as though the macro is looking for a connection that no longer exists and needs to find a new connection. Does anyone know of changes to the code to get rid of this error. OR more preferably a way to refresh the PowerPivot data within the excel spreadsheet?
Any help is greatly appreciated!
