Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.

Reply to message

View discussion in a popup

Replying to:
TK_Firewire
Level 1

Reply to message

Adrian we are having the same issue. Spent 90 minutes with QB tech support yesterday on this ticket: Case:[removed] TECH_SUPPORT. We have 2 users with this issue. Multiple browsers, cleared caches, checked options in Excel. They need to export from QB Online to excel to bring client information into other accounting software we use. QB Online creates the trial balance and other reports in the excel file with formulas (ie =1234.56 instead of number 1234.56). All the cells with these formulas display zero. When user opens the file on their computer there is a MS warning across top about protected view. Most of our users click the edit button on this message and the zeros convert to the number. However 2 of them still see zeros; one has Excel 2016 other 2019. If they doubleclick each formula individually they can display result. Yes automatic recalculation is set to ON. Format is general. All their excel options (FILE/OPTIONS) seem to be the same as those who's systems work as expected. While I suspect the problem is with Excel we need your help since it's only happening when we export from QB Online - no other systems cause this problem. For everyone else we did develop a workaround if you have Adobe Acrobat (full version not reader). Export and save the trial balance report as a PDF instead of Excel. Then using Acrobat tool "Export PDF" select spreadsheet and open that way. Works well with trial balance but other reports (esp balance sheet) may not format correctly. Adrian please help this is very frustrating.

Need to get in touch?

Contact us