Excel file getting corrupt after saying yes to this - "be careful! parts of your document may include personal information that can't be removed by the document inspector."

See more:

MS-Excel

I have written a macro that opens an excel template, does some calculations on it and then SaveAs "" it. Problem is while saving the file I am getting this notification - "

Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector.

Clicking OK renders a corrupt excel file while clicking cancel does not save the file at all.

Though at first I was saving it by simply giving path and file name (D:\folder1\file.xlsx), later I tried it with mentioning general information I found on net(

Filename:="C:\Data\" & BookName, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

), but with no gain.

I am using Excel 2013.

This problem arose all of a sudden. Before the code gave perfect result.
Any idea what is this?

Thanks.

What I have tried:

I tried with

Filename:="C:\Data\" & BookName, FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

I even replaced xlNormal with 51 as I found but it still does not work.