Whenever I export balance sheet in excel from QBO, the excel sheet have all the account heads but for each the balance is zero.

The error is not occuring for exporting in pdf or printing directly but is only happening when I export in excel. How do I fix this?