ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lost External Data Connections (https://www.excelbanter.com/excel-discussion-misc-queries/150008-lost-external-data-connections.html)

Jeff C

Lost External Data Connections
 
I had a number of spreadsheets/Pivot tables set up linked to MS Access Queries.

I got the bright idea of installing Office 2007 Excel last week hoping to
try and figure it out. I installed that application only specifying to leave
the existing 2003 Excel intact. I assumed I would be able to run them
independently but was obviously wrong.

When my old Workbooks opened they opened in Excel 2007 Compatability mode
and not having the time I uninstalled the Office 2007 application. Since
then my linked pivot tables are broken and whenever I try and connect using
new external data source I am having to go through a series of unfamiliar
setup steps and half the time it does not work, I get the "Expected 3
Parameters" message.

Can anyone tell me how to resolve this problem? Or offer any advice or
reading?

Thank you in advance
--
Jeff C
Live Well .. Be Happy In All You Do


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com