cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Unlock the full power of QuickBooks with our Training Classes - Discover more
klous-1
Level 4

Stock Valuation summary report XLS zero

Seems like the EXCEL export Stock Valuation Summary report, from Classic view, shows all zero values incorrectly.

 

Exporting to Google sheets works correctly.  Modern view shows the values.

 

Tried several computers, private window.

 

2025-02-14 12_12_27-SOLUTEX+Ltd_Stock+Valuation+Summary.xlsx  [Protected View] - Excel.png

Solved
Best answer 2 weeks ago

Accepted Solutions
CharleneMaeF
QuickBooks Team

Stock Valuation summary report XLS zero

Hi, klous-1. I appreciate you sharing the steps you've taken to rectify the issue.

 

I'm here to ensure you can view the correct amount in the Stock Valuation Summary report.

 

When you export reports from QuickBooks Online to Excel, the file opens in Protected View as a security measure to shield your computer from viruses, worms, or other malware that might cause damage. This is why you're only seeing zero values on the Excel page.

 

To sort this out, I recommend clicking the Enable Editing button located at the top of the Excel file. For visual reference, I've added a screenshot below:

 

Additionally, I'm adding these articles to help you get the most out of your QuickBooks reports: 

 

 

Please let me know in the comments below if you have additional questions or concerns about exporting reports in QuickBooks. I'd be glad to assist. Keep safe, and have a nice day.

View solution in original post

2 REPLIES 2
CharleneMaeF
QuickBooks Team

Stock Valuation summary report XLS zero

Hi, klous-1. I appreciate you sharing the steps you've taken to rectify the issue.

 

I'm here to ensure you can view the correct amount in the Stock Valuation Summary report.

 

When you export reports from QuickBooks Online to Excel, the file opens in Protected View as a security measure to shield your computer from viruses, worms, or other malware that might cause damage. This is why you're only seeing zero values on the Excel page.

 

To sort this out, I recommend clicking the Enable Editing button located at the top of the Excel file. For visual reference, I've added a screenshot below:

 

Additionally, I'm adding these articles to help you get the most out of your QuickBooks reports: 

 

 

Please let me know in the comments below if you have additional questions or concerns about exporting reports in QuickBooks. I'd be glad to assist. Keep safe, and have a nice day.

klous-1
Level 4

Stock Valuation summary report XLS zero

You are correct!  My error sorry.

Need to get in touch?

Contact us