Odd VBA error

Hello

I have a xls file which I've used regularly for a few years and is c.4MB in size

In the last few months I've at ad-hoc times been getting an error message regarding 'VBA' - something which I never use (or aware that I use!).

The error box says 'Microsfot VisualBasic for Applications as the header' and then in the box says 'Can't find project or library'.

A little googling has said that I should hit Alt+ F11 and then go to tools>>references and remove anything which says 'missing'. However when I do this, I can go to Tools, but whilst References is there and not greyed out, I am unable to click on it (or if I click on it it does nothing).

I've tried re-installing Office; sometimes this works, sometimes it doesnt. Does anyone have any idea about what this is or might be causing it, and obviously how I prevent it?

Any advice very gratefully received!!!
Thanks

Adam

Sorry - one addition. This error prevents me from saving the file, or I get a warning saying that if I save it I will lose some features

It may be the fact you are running a very old file (.xls) with your 365 - try saving the file as .xlsm (macro enabled) and see if that is more stable.
torachan.

Hi Torachan

Thanks for the swift reply. Just checked and its already a .xlsm file I'm afraid. Are there any other tips which you might have?
Thanks

Adam

Hi Rorya

I'm not sure what requires a macro format excel and what doesnt. I use the Data function in Excel to import share prices, I link a few things to other files, I use conditional formatting, some data tables etc. Everything else is relatively standard excel.

However I haven't written any macros for it. What requires VBA or a macro enabled workbook?
Thanks

Adam