Forum Discussion

duncan1525's avatar
duncan1525
Copper Contributor
Jul 23, 2024

No formulas are working

Hello, I am new to here....

 

I have a spreadsheet (huge) that appears to be corrupted some way. is is saying that even simple formulas ´=sum(f4+f5) are ´value´. it will not add up lines of cells, in fact no formulas work at all. I have deleted and reinstalled excel, new spreadsheets are not affected, but this one spreadsheet is. Can anyone help me clean this spreadsheet?

 

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    duncan1525 Would be helpful if you could share the file. Remove any confidential information though. Share a link that gives access to your file on OneDrive or a similar file sharing facility.

    • duncan1525's avatar
      duncan1525
      Copper Contributor

      Riny_van_Eekelen thank you for your response - I have worked it out! I started off the spreadsheet on a UK computer and now am working with a Spanish one. So instead of ´12.8´ I need to put ´12,8´a comma not a dot! Spanish computers don´t recognise the dots!!!

Resources