problems with my excel file

Question

I've got an excel containing all my investments in stock etcetera. Whenever I open this file on the webversion of excel (via OneDrive) all my formula's work. But whenever I open this file on the desktop version my stock names just dissapear. An example:

This is a screenshot of how my file SHOULD work. Whenever I open it on the desktop version. The following problem occurs:

My excel is in Dutch, so "#ONBEKEND!" means "unknown". Does anyone know how to solve this problem? I've been spending literally hours today in trying to fix this, but without any result.

Answer 1

Are you using version 16.91?

Did you activate using a subscription?

To find out, use the Menu Bar and choose Excel > About Microsoft Excel.

Answer 2

I just bought microsoft office for 70 euro's. But I still have the same problem. I can't even get the "ticker" formula to work. Usually you can use the following formula to get the ticker:

=[@Stock].[Ticker symbol]

Or for the stock prices:

=[@Stock].[Price]

etc.

Now I get a error saying the following:

This is a online picture BTW, but it's the exact same error. I completely lost for answers at the moment haha, if anyone got tips I would appreciate it.

Answer 3

The web version is free, but does not support all of the versions of the desktop version.

You did not tell us what desktop version is involved. The current desktop version is 16.91 and that should work if it is activated with a subscription license.

Answer 4

Hmmm, it says my excel version doesn’t support it. But how can I the file work on the web then? Very strange.

Answer 5

Maybe in the desktop app > Formulas > Formula Auditing see error checking & evaluation