ChainlinkMarines
New Member
- Joined
- Jun 16, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hello All,
Hope this finds you well. Within a large, multi-tabbed workbook, some Excel formulas which always worked fine were suddenly replaced by: =N/A#. How did this corruption happen?
Other info:
1) Please note it is not a problem with the way the formulas were written; they always functioned well before
2) There is no pattern to which formulas it corrupted this way; for example in some cases in a given column, the same formulas for the first few rows remain and then at a certain point get replaced by the =#N/A
3) My Microsoft Office 2010 version started exhibiting a Product Activation Error a few weeks ago so I will likely purchase a new legit version today. But does this have anything to do with corrupting the file in the aforementioned way- wouldn't it just stop working? Strangely it DOES open certain older Excels still!
4) I have Kaspersky anti-virus software, in case that's relevant
5) This Excel workbook was literally born in 1995 and has been expanded/upgraded/made more complex ever since
Many thanks!
Hope this finds you well. Within a large, multi-tabbed workbook, some Excel formulas which always worked fine were suddenly replaced by: =N/A#. How did this corruption happen?
Other info:
1) Please note it is not a problem with the way the formulas were written; they always functioned well before
2) There is no pattern to which formulas it corrupted this way; for example in some cases in a given column, the same formulas for the first few rows remain and then at a certain point get replaced by the =#N/A
3) My Microsoft Office 2010 version started exhibiting a Product Activation Error a few weeks ago so I will likely purchase a new legit version today. But does this have anything to do with corrupting the file in the aforementioned way- wouldn't it just stop working? Strangely it DOES open certain older Excels still!
4) I have Kaspersky anti-virus software, in case that's relevant
5) This Excel workbook was literally born in 1995 and has been expanded/upgraded/made more complex ever since
Many thanks!