We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server

Nirvana67

New Member
Joined
Oct 3, 2012
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
I have been building Call center Planning Models on Power Pivot 2013, and in concept, it's great. I am marrying forecast data sheets to actual data sheets and using a myriad of lookup tables to glue it all together. The program doesn't seem to have a problem picking up new data on the actual results and forecast data sheets as I update them. For some reason, the lookup tables have an issue refreshing, whenever I add something to them, or when there is a change in the data. No new column, just adding rows to the bottom, or editing what is already there. Sometimes they do update when their is a change, sometimes they don't. When they don't I get the dreaded, "We couldn't refresh the connection. Please go to existing connections and verify they connect to the file or server". The only fix I have been able to do so far is to re-import and rebuild the areas of the workbook that are involved, re-do the relationships, etc. This is not really acceptable as it is a huge pain in the neck, and I couldn't roll something like this out to others in this unstable state.

So the question is, can someone tell me the best practice for putting something like this together. Current state is that I have a workbook with a lookup table per tab. I import these tables from this one workbook to multiple Power Pivot Workbooks. Would it be better to house the tables in Access? I really want to centralize these tables, and not have to have a complete set of these tables in every power pivot workbook. I have searched on the web, and have not found a solution. The models work great, until something changes. I should not have to rebuild the model every time I incorporate more areas in these tables.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
There is nothing wrong with your approach - it is perfectly valid. Unfortunately it is very difficult to work out what the issue is. Have you tried loading the tables using Power Query? I am not saying it is better (or worse), just different.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top