Stockhistory not working on excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2238418%22%20slang%3D%22en-US%22%3EStockhistory%20not%20working%20on%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2238418%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20365%20license%20and%20use%20both%20a%20windows%20PC%20and%20a%20Mac.%20On%20windows%20the%20stock%20history%20function%20has%20disappeared%20while%20I%20can%20see%20and%20use%20the%20'stocks'%20function%20in%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20Mac%20the%20stock%20%26amp%3B%20geography%20functions%20have%20disappeared%20totally%20%2C%20the%20data%20wont%20refresh.%20Bizarrely%20the%20stockhistory%20function%20is%20in%20excel%20but%20when%20you%20try%20and%20run%20it%20it%20shows%20%23BLOCKED.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20apprecaited%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have a 365 license and use both a windows PC and a Mac. On windows the stock history function has disappeared while I can see and use the 'stocks' function in data. 

 

On a Mac the stock & geography functions have disappeared totally , the data wont refresh. Bizarrely the stockhistory function is in excel but when you try and run it it shows #BLOCKED. 

 

Any help would be apprecaited 

0 Replies