Hi,

I've issue with some of my users who are using PA formulas in Excel (Perspectives).

Specifically, the values generated by these formulas appear with a strikethrough formatting.

However, standard Excel formulas and static values (like snapshots) display correctly without any issues.

When the Excel file is sent to another user, the strikethrough formatting disappears.

Has anyone experienced something similar? If so, do you have any insights or potential fixes for this issue?

Thanks

Hi Roei,

I have the same issue with strikethrough formatting on Perspectives. 

I'm not sure which version of Excel you are using. I found the new Excel version (2410) have Stale Value Formatting function, that occurs when the calculation option on the Formulas ribbon set to Manual. Please see the link below for references.

https://support.microsoft.com/en-us/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd

https://answers.microsoft.com/en-us/msoffice/forum/all/every-cell-containing-a-formula-appears-striked/75e5ee4f-850c-4c54-b813-34bbebbabb2a

Regards,

Hi Roei,

I have the same issue with strikethrough formatting when using Perspectives.

I'm not sure which version of Excel you are using. I found the new Excel version (2410) have Stale Value Formatting function, that occurs when the calculation option on the Formulas ribbon set to Manual. Please see the link below for references.

https://support.microsoft.com/en-us/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd

https://answers.microsoft.com/en-us/msoffice/forum/all/every-cell-containing-a-formula-appears-striked/75e5ee4f-850c-4c54-b813-34bbebbabb2a

Regards,