Too many PowerPivot Connections?

Have you ever created a PowerPivot in Excel, then changed the data source, and things didn't seem to work right? Maybe it acted like the data was coming from different servers, some from the old server, and some from the new server. It is very easy to get yourself into this situation, without even realizing it. Here is what you might do.