I use an indirect function
=INDIRECT(defaults.c7 & "44564")
where I reference
C7 in sheet
C7 cell contains a column letter.
Directly after loading the document. I get a
When I click on the cell with the
#NAME? error and use
to edit the function the result of
0 will be shown and when clicking just OK the error is gone, and the cell contains
I have no idea what is wrong here.