Connect with and learn from others in the QuickBooks Community.
When I export a report such as the Balance Sheet to Excel in Quickbooks Desktop Pro 2017, I save the file as an XLSX. However, Excel warns me:
"The following features cannot be saved in macro-free workbooks:
-Excel 4.0 function stored in defined names"
When I open Name Manager in Excel, I see that Quickbooks has various names defined.
My question: if I save the workbook as an XLSX, what functionality am I going to miss out on? The numbers themselves won't be affected, correct?
Go to Solution.
Let me help you out, Titan321214.
You encounter that error message when saving an Excel workbook. To save a file with these features, click No, then select a macro-type in the file list.
Although, if you select XLSX, you won't miss anything since we support that file type and the numbers will not be affected.
Let me also add this article on how to fix QuickBooks Desktop if it crashes when exporting report to Excel worksheet as a future reference.
You can get back to this thread if you have more questions. We're just a comment away.
View solution in original post