Partial column without numbers

Hello all,

I have a problem and would appreciate some help. Hope this is the right subforum and the question does not belong in "Excel Formulas and Functions". Please move it if needed.

The following situation: in file 1 there is a query (Analysis for Office). In file 2 there are several spreadsheets, of which 1 spreadsheet (XYZ) is linked to all cells of the query from file 1. The other spreadsheets in file 2 also partially access numbers from spreadsheet XYZ using formulas. When working with file 2 (e.g. show and hide and many more, possibly also in spreadsheet XYZ) it happened that a whole column of spreadshteet XYZ showed only zeros. Unfortunately, I didn't approach this systematically, so I can't determine which step caused the later reappearance of the numbers. Do you have any ideas?

Thanks in advance!
Dirk

Hi,

the profile is updated.

No text should appear in the cells, it's about numbers. They appear now also again, only I do not know why they were not shown in the meantime and there were only zeros to see.

The formula used is of the type: ='[abc.xlsx]query'!w13 Maybe it was because it is a query ( Analysis for Office) and there is something to consider?

Hi Marvin,

I saw zeros instead of "natural numbers. There are figures in the query, for example 10.000, 5.555 and so on. File 2 ist linked to these figures and they were shown in the spreadsheet in file 2. Suddenly they disappered and i only saw zeros. After some handling with file 2 they were shown again as 10.000, 5.555 and so on. I do not understand this and am afraid, that it will happen in future too.

Good night, in Germany its time to go to bed