PowerPivot Refreshing Data Automatically within Excel Window

fr650008

New Member
Joined
Jun 21, 2014
Messages
9
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!
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

fr650008

New Member
Joined
Jun 21, 2014
Messages
9
I forgot to mention that my PowerPivots are connected to a Microsoft 2012 SQL database and we currently do not have sharepoint.
Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,162
Members
410,775
Latest member
alal1030
Top