Error on 'Accounts' tab

There is a problem in my ‘Accounts’ tab. The tab is empty (except for the header row). Cells F2, G2 and H2 say REF!. Cell J1 says, ‘#VALUE’ and there is an error on that cell which says, “In ARRAY_LITERAL, an Array Literal was missing values for one or more rows”.

What can I do to fix this?

If it happened recently, I’d use the “File/Version History” tool to go back to a version where it was working. Otherwise, I’d check if anything is typed into one of the cells in column G by selecting G3:G and hitting delete. If that doesn’t fix it, it could be a problem with the Balance History sheet, which is where Accounts gets it data from.

Thanks @jpfieber. ‘selecting G3:G and hitting delete’ solved the problem.

1 Like