Stockhistory Problem, #Blocked Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2206615%22%20slang%3D%22en-US%22%3EStockhistory%20Problem%2C%20%23Blocked%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206615%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Gurus%2C%3C%2FP%3E%3CP%3EGot%20a%20problem%20with%20Stockhistory.%26nbsp%3B%20I'm%20using%20Office%20365%20desktop.%26nbsp%3B%20When%20I%20try%20to%20execute%20the%20function%2C%20it%20throws%20a%20%23Blocked%20error.%26nbsp%3B%20The%20error%20has%20a%20note%20that%20says%3A%20%22You're%20unable%20to%20view%20data%20types%20with%20your%20current%20privacy%20settings.%22%26nbsp%3B%20Searching%20MS%20Support%20I%20found%20this%20page%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fhow-to-correct-a-blocked-error-13be117b-92e4-400a-a215-aa59d37d6e7c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fhow-to-correct-a-blocked-error-13be117b-92e4-400a-a215-aa59d37d6e7c%3C%2FA%3E%3C%2FP%3E%3CP%3Ewhich%20purports%20to%20show%20how%20to%20fix%20%23Blocked%20errors.%26nbsp%3B%20It%20has%20specific%20instructions%20for%20the%20%22privacy%20settings%22%20error.%26nbsp%3B%20But%20following%20the%20instructions%20to%20change%20privacy%20settings%20has%20no%20effect.%26nbsp%3B%20I%20have%20logged%20out%20and%20back%20in%20after%20making%20setting%20changes.%26nbsp%3B%20Still%20no%20effect.%26nbsp%3B%20I%20made%20sure%20my%20Office%20version%20is%20up%20to%20date.%26nbsp%3B%20I%20also%20reviewed%20the%20other%20issues%20that%20can%20cause%20the%20%23Blocked%20error%20and%20none%20of%20those%20appear%20to%20apply%20either.%26nbsp%3B%20I%20wasted%20the%20better%20part%20of%20an%20hour%20with%20tech%20support%2C%20but%20they%20were%20useless.%26nbsp%3B%20Actually%2C%20they%20said%20that%20you%20guys%20knew%20the%20apps%20better%20than%20they%20did.%26nbsp%3B%20So%20...%20anybody%20seen%20this%20before%3F%26nbsp%3B%20Any%20ideas%20on%20how%20to%20debug%20the%20error%3F%26nbsp%3B%20Any%20suggestions%20much%20appreciated!%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2206615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2206649%22%20slang%3D%22en-US%22%3ERe%3A%20Stockhistory%20Problem%2C%20%23Blocked%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2206649%22%20slang%3D%22en-US%22%3EUpdate%3A%20I%20found%20the%20problem.%20Will%20post%20this%20for%20anyone%20who%20may%20run%20into%20the%20same%20glitch.%20I%20just%20systematically%20went%20through%20and%20disabled%20every%20privacy%20setting%20I%20could%20find%20(ie%20-%20no%20privacy%20limitations).%3CBR%20%2F%3EThe%20one%20that%20made%20it%20work%20was%20in%20Account%2FAccount%20Privacy%20Settings%3A%20Connected%20Experiences%3A%20%22Let%20Office%20analyze%20your%20content%20to%20provide%20you%20with%20improvements.%22%20Yeah%2C%20doesn't%20sound%20like%20it%20would%20have%20anything%20to%20do%20with%20Stockhistory%2C%20but%20when%20I%20clicked%20the%20check%20box%20to%20enable%20this%20option%2C%20it%20cleared%20the%20%23Blocked%20error%20and%20Stockhistory%20is%20now%20working%20fine.%3C%2FLINGO-BODY%3E
New Contributor

Hello Gurus,

Got a problem with Stockhistory.  I'm using Office 365 desktop.  When I try to execute the function, it throws a #Blocked error.  The error has a note that says: "You're unable to view data types with your current privacy settings."  Searching MS Support I found this page:

https://support.microsoft.com/en-gb/office/how-to-correct-a-blocked-error-13be117b-92e4-400a-a215-aa...

which purports to show how to fix #Blocked errors.  It has specific instructions for the "privacy settings" error.  But following the instructions to change privacy settings has no effect.  I have logged out and back in after making setting changes.  Still no effect.  I made sure my Office version is up to date.  I also reviewed the other issues that can cause the #Blocked error and none of those appear to apply either.  I wasted the better part of an hour with tech support, but they were useless.  Actually, they said that you guys knew the apps better than they did.  So ... anybody seen this before?  Any ideas on how to debug the error?  Any suggestions much appreciated!

Thanks!

2 Replies
Update: I found the problem. Will post this for anyone who may run into the same glitch. I just systematically went through and disabled every privacy setting I could find (ie - no privacy limitations).
The one that made it work was in Account/Account Privacy Settings: Connected Experiences: "Let Office analyze your content to provide you with improvements." Yeah, doesn't sound like it would have anything to do with Stockhistory, but when I clicked the check box to enable this option, it cleared the #Blocked error and Stockhistory is now working fine.

@savvyjack

would appreciate more help if your can.  Stockhistory worked earlier today.  Now it is blocked error.  I attempted to do what you described above but cannot get to a screen that shows that option to enable or disable.  Can you please provide more instruction  Thanks