cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Export report to Excel, features cannot be saved in macro-free workbooks

Hello,

 

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?

Solved
Best answer August 10, 2020

Best Answers
Highlighted
QuickBooks Team

Export report to Excel, features cannot be saved in macro-free workbooks

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

1 Comment
Highlighted
QuickBooks Team

Export report to Excel, features cannot be saved in macro-free workbooks

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

Need to get in touch?

Contact us