be careful parts of your document may include personal information that cannot be removed by the Document Inspector

sql-server excel excel-2013 powerpivot
Ardalan Shahgholi picture Ardalan Shahgholi · Jan 21, 2014 · Viewed 72.2k times · Source

I use Excel 2013 and Power View and SQL Server 2008 R2.

After create my Data Source and my chart in Excel When I want save my Excel file I get this message

be careful parts of your document may include personal information 
that cannot be removed by the Document Inspector.

What is this warning and how I can remove this message? What are personal information that exist in my Excel File.

enter image description here

Answer

n1000 picture n1000 · Feb 7, 2014

Also ran into that. It seem, after running the Document Inspector in Excel, it will show you this warning whenever you save your file. Go to File > Info and click in "Allow this information to be saved in your file". The next time you save there should be no more warning.

enter image description here

Related questions

Import Excel spreadsheet columns into SQL Server database

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard didn't offer that option. Do any easy code options exist?

Read More
Export SQL query data to Excel

I have a query that returns a very large data set. I cannot copy and paste it into Excel which I usually do. I have been doing some research on how to export directly to an Excel sheet. I am …

Read More
'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data) It is not the same …

Read More