This sort of error is because the file is opened directly from the web.

 

Microsoft lets you open Word and Excel files like this ... from inside Microsoft Explorer

but in this case its a bad idea - and stops the macros working properly.

 

read on for the solution..

   

 

to fix this, go back and right click the original link, then ...
choose Save Target As, and ..

 

Choose where you want to save it (eg My Documents or Desktop) press SAVE

Once its downloaded press OPEN..

 

 

 

 

 

Remember to choose Enable Macros as it opens ...

OK ...

Now you've got it open in Excel (not inside Internet Explorer) properly. 

back