Difference between revisions of "Excel Troubleshooting"
Jump to navigation
Jump to search
(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]...") |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
[[Excel 2010 against a SQL 2005]] | [[Excel 2010 against a SQL 2005]] | ||
| Line 9: | Line 7: | ||
[[Excel 2010 SQL 2000 OLAP reporting – won't refresh]] | [[Excel 2010 SQL 2000 OLAP reporting – won't refresh]] | ||
| − | + | == 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". | + | The default connection files are saved in "<tt> C:\Program Files (x86)\Microsoft Office\Office12\QUERIES </tt>" for Office 2007 in Windows 7 64 bit. For 32 bit its here "<tt> C:\Program Files\Microsoft Office\Office12\QUERIES </tt>". |
| − | 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. | + | Connection files added by users are saved in their profile "<tt> C:\Users\{USERNAME}\Documents\My Data Sources </tt>" 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/ | http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/6a68d87e-cd9d-4383-99e1-4b522e305f6b/ | ||
Revision as of 09:00, 1 December 2013
Microsoft Pivot Table Services for SQL Server 2005 was not properly installed
Excel 2010 SQL 2000 OLAP reporting – won't refresh
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/
