Excel Troubleshooting

From DataSelf Knowledge Base
Revision as of 08:59, 1 December 2013 by Dataself (talk | contribs) (Created page with "h1. Excel Troubleshooting Excel 2010 against a SQL 2005 Microsoft Pivot Table Services for SQL Server 2005 was not properly installed [[Excel report refresh failed]...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

h1. Excel Troubleshooting

Excel 2010 against a SQL 2005

Microsoft Pivot Table Services for SQL Server 2005 was not properly installed

Excel report refresh failed

Excel 2010 SQL 2000 OLAP reporting – won't refresh

h2. Connection file locations

The default connection files are saved in "C:\Program Files (x86)\Microsoft Office\Office12\QUERIES" for Office 2007 in Windows 7 64 bit. For 32 bit its here "C:\Program Files\Microsoft Office\Office12\QUERIES".

Connection files added by users are saved in their profile "C:\Users\{USERNAME}\Documents\My Data Sources" on a Windows 7 system. You can delete these files and they will get removed from the "Existing Connections" dialog.

http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/6a68d87e-cd9d-4383-99e1-4b522e305f6b/