98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Links
Links
Resolved · Low Priority · Version 2007
Michael has attended:
Excel Intermediate course
Links
Hi
We use an excel timesheet at work that is linked to a central timesheet. Each time I go into either my personal or the central timesheet I get a security warning - "Some active content has been disabled" and have to click on "options" and choose "enable this content" for each issue - macro, data connection etc...I would like all content to be enabled all the time for these worksheets - how do I change it so I dont have to "enable" every time I go into the worksheet?
Tks in anticipation,
Mike
RE: Links
Hi Michael
Thanks for your question
Click on the Office Button, and select options. Go to Trust centre and select external content. Under "Security settings for workbook links" select "Enable automatic update for workbook links".
Note this does provide a security flaw and you should only link the file to workbooks where you are certain that they present no security risks
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |