Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
T
titan321214
August 11, 2020
Solved

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

  • August 11, 2020
  • 1 reply
  • 12 views

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?

Best answer by Kristine Mae

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.

1 reply

Kristine Mae
Kristine MaeModeratorAnswer
Moderator
August 11, 2020

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.

V
VaTT
June 8, 2021

As a follow-up to this conversation: If I save to .xlsm format, Quickbooks will not update the spreadsheet as it does not support .xlsm file format. What is my solution to save macros and be allowed to update from QuickBooks

    C
    CharleneMaeFQuickBooks Team
    QuickBooks Team
    June 8, 2021

    I'm here to ensure you're able to save and update your report in Excel, VaTT.

     

    Since we have a specific format when saving reports in QuickBooks Desktop,  you can use a file converter to do this. I'd suggest visiting our Intuit Marketplace to look for a third-party converter.

     

    After that, you can export the report. Then, you can get the latest version of the data from QuickBooks while you're in Excel. I'll show you how.

    1. In Microsoft Excel, go to the QuickBooks tab. Excel adds this automatically the first time you export the report.
    2. Select Update Report to get the latest version of the report from QuickBooks.

     

    For more details in saving your report, please this article: Export Reports to Excel from QuickBooks Desktop.

     

    Additionally, you can customize any report that you generate in QuickBooks. This helps you add the specific details you'd like to see in the data before exporting it to Excel.

     

    Feel free to comment down below if you have any other report-related concerns or questions. I'm always glad to help in any way I can.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement