Difference between revisions of "Excel Troubleshooting"

From DataSelf Knowledge Base
Jump to navigation Jump to search
 
Line 1: Line 1:
 +
 +
 +
[[Excel Data Security]]
 +
 
[[Excel 2010 against a SQL 2005]]
 
[[Excel 2010 against a SQL 2005]]
  
 
[[Microsoft Pivot Table Services for SQL Server 2005 was not properly installed]]
 
[[Microsoft Pivot Table Services for SQL Server 2005 was not properly installed]]
 +
 +
[[Excel Lock Files]]
  
 
[[Excel report refresh failed]]
 
[[Excel report refresh failed]]

Latest revision as of 23:46, 13 March 2015


Excel Data Security

Excel 2010 against a SQL 2005

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

Excel Lock Files

Excel report refresh failed

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/