table1[column] not saved

[Wilco()]

I have formula which refers to a table:
=COUNTA(table1[number])-SUM(B4:B17)

Which works fine. I save the document.
When I reopen the document the formula has been changed to:
=COUNTA('ServiceNow Data'!$A$2:$A$199)-SUM(B4:B17)

Why is this happening?

I have this with another formula as well.

I use Excel 2016.

 

[NARAYANK991]

Hi ,

While your formula shows static references , is your table still intact ?

If you can upload your file , you can get an answer immediately.

Narayan

 

[Wilco()]

Table is still intact. I have tried to change the formula and save it. And it happens again and again.

I have saved it under another name and as an xlsx document. Now the issue is gone