Problem with Excel

[Orchid1]

I'm currently having a problem with Excel where when I right click to try and copy something to paste it elsewhere the "copy" option is greyed out and won't let me select it. It's also the same if I try and right click on a tab down at the bottom to rename it for example.

It's not the mouse as that works everywhere else and I can still use Control C and Control V but that's too much of a hassle for what i'm trying to do.

Anybody any ideas how to fix?

[Orchid1]

Turns out I also can't drag down formulas as well?

[louiebaby]

Is the workbook protected or something?

If this is something you've created from scratch it might be a different issue compared to if it was something sent over by a supplier, for instance.

[Orchid1]

It's not protected and it's just a fresh blank excel page i've opened up :s.

[louiebaby]

We have MS Office 365 here, and there was a relatively big update a couple of days ago.

Do you need a re-boot or something similar to make sure all the updates have "taken" properly?

[Orchid1]

louiebaby said:

We have MS Office 365 here, and there was a relatively big update a couple of days ago.

Do you need a re-boot or something similar to make sure all the updates have "taken" properly?

Don't think so, it started doing it yesterday afternoon but I thought it would have corrected itself by today but looks like it hasn't.

[FunkyGibbon]

Try this:

https://support.office.com/en-us/article/repair-an...

then this to reset excel...

C:\Users\User Name\AppData\Roaming\Microsoft\Excel

Please change the file ExcelXX.xlb to ExcelXX.xlb.old.

HTH