vlookup, xlookup functions does not function in excel and more

Ranko Skansi 0

Dear sirs, I have Office 365 correctly updated and I found out that in Excel, functions (vlookup, and xlookup - I din't try other) doesn't work. At the same time, in Word, there's no note about Saving to the disk, as was before. Usually Word writes "Saved to this PC" close to the Title of the document in the top of the screen. Now I don't have that option, as the word acts like notnig happend after I pressed Ctrl+S!

Your help on this matter will be more that appreciated!

Barry Schwarz 3,071 Reputation points

2024-09-22T19:52:29.9466667+00:00

You need to provide some details, such as a sample of what doesn't work.
Ranko Skansi 0 Reputation points

2024-09-23T11:13:58.1066667+00:00
Ranko Skansi 0 Reputation points

2024-09-29T11:02:47.83+00:00

Hello Barry, I attached screenshot of what is missing. Before I had script "Saved..." and now it is gone.

1 answer

Emi Zhang-MSFT 25,631 Reputation points Microsoft Vendor

2024-09-23T01:42:01.2366667+00:00

Hi,

For Excel function problem, I suggest you check if the first column in the cell range contain the lookup value. Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

For Word problem, I suggest you go to File- Options- Save and check the option "Save to Computer by default":

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Ranko Skansi 0 Reputation points

2024-09-23T11:12:09.8866667+00:00

Dear Emi, many thanks for your kind answer, butu the situation with Word hasn't change at all. I tried to uncheck and Save, then to check again and Save, but there's still no sign of File being saved.

Ranko Skansi 0 Reputation points

2024-09-23T11:12:44.78+00:00

Ranko Skansi 0 Reputation points

2024-09-29T11:05:44.0533333+00:00

I did what you suggested but nothing changed in my Word. (Pls see my screenshot attached before). I don't have note "Saved" anymore.

Emi Zhang-MSFT 25,631 Reputation points Microsoft Vendor

2024-10-01T07:30:00.7433333+00:00

Hi,

Please go to File- Account and provide the screenshot about the Account information.

Ranko Skansi 0 Reputation points

2024-10-02T07:35:04.2633333+00:00

Emi Zhang-MSFT 25,631 Reputation points Microsoft Vendor

2024-10-02T09:13:53.3566667+00:00

Hi,

You're using the fixed update Office, emm...

https://support.microsoft.com/en-US/office/word-save-status-is-missing-in-the-title-bar-for-locally-saved-files-907c0fd1-b111-470e-847b-92f78f98aae4

Can you try to check if there are new updates and update it.

Then go back to File- Options- Save- make sure the option "Don't show the Backstage when opening or saving files with keyboard shortcuts" is uncheked:

Ranko Skansi 0 Reputation points

2024-10-02T13:02:07.2366667+00:00

Thanks, it is corrected now! Have a nice day!!!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

vlookup, xlookup functions does not function in excel and more

1 answer

Your answer