• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula Update/Don't Update Prompt

K

krissi18d

New Member
Recently converted over to microsoft 2010. I use files daily that i need the prompt to update / not update at the time of opening the file. I'm only receiving this in some documents, but it's an all or nothing set up, so i think there is something else preventing the prompt from popping on all files, copy of files. Has anyone else experienced this? my IT department is stumped.
 
can you post a pic or the actual text of the message?


is it about external links to other workbooks?
 
There is no text. I just don't received the pop up box when opening a document that i can select Update / Don't Update. It seems i either get the enable content box or the update / don't update box, but i can't seem to get both options to pop. The scroll i get on the top when i open documents that use to give me the update / don't update prompt, i now get a Security Warning: Some active content has been disabled. Click for more details. Enable Content. I have tried every security setting and i have got to be missing something.
 
Hi krissi18d!


First of all.. Welcome to the forum..


Can you please do me a favor..

Excel > VBA (Press Alt + F11) > Goto Immediate Window (Press Ctrl +G) and write

[pre]
Code: 
? Application.AutomationSecurity
-- Provide us the Numeric Digit..

? Application.AskToUpdateLinks
[/pre]
-- Provide us the answer (True / False)..


Regards,

Deb
 
Hi ,


To add to what Deb has posted , the explanation for these is :


?Application.AutomationSecurity

[pre]
Code: 
2	Uses the security setting specified in the Security dialog box.
3	Disables all macros in all files opened programmatically, without showing any security alerts.
1	Enables all macros. This is the default value when the application is started.
You should see 1 as the result of the command.


[b]?Application.AskToUpdateLinks


This can give a result of [b]True[/b] or False[/b].


You should see True[/b] as the result of the command.


If either of the results is not what it should be , you can change the settings by giving the following commands , again in the Immediate Window :

Application.AutomationSecurity = 1

Application.AskToUpdateLinks = True
[/pre]
Narayan
 
Hi Krissi18d!


One more request.. Can you please open the same file from Explorer.. > Mention Files Icon.. > Shift + Right Click.. > Open in Protected View


Is it now asking to update LINKS..!! Its something like Open in SafeMode.. :)


If you default setting is "not to ask" or "permit all.. "

Opening the file by above process.. will bypass it.. :)


BTW.. If you have just upgraded yourself to 2010.. the alert showing in 2007 is just changed to below format.. :)

https://dl.dropbox.com/u/78831150/Excel/HowAlertLookLike.png


@ Narayan..

Thanks buddy..


Regards,

Deb
 
You must log in or register to reply here.
Back
Top