Excel and Big Sur

Hello,
after upgrading to Big Sur, I've started encountering different problems with Excel, a couple of examples:
CSV: When I opened before a simple csv file, I used to see immediately the data splitted in different columns, now this is not happening anymore, I just see everything in one row.
FORUMLA: I'm working on the same file I was working before the update, and I'm not able to create any new formula, as I keep getting a VALUE error.
Is not about formatting, I've also sent the file to a collague and everything works perfectly on her Windows environment.

Has anyone faced similar problems?

Thanks in advance,
Davide
please give a simple example (real) of formula that doesn't work.

For CSV, have you checked separator ? may be some setting has changed.

Hey, did you manage to fix this and how as I have encountered the same problem :(

Excel and Big Sur
 
 
Q