Excel 2007 Trusted Network Location not running VBA macros
Posted on 2013-12-02
Hello all, I am perplexed by this. I have an Excel 2007 spreadsheet which uses a VBA macro for various operations upon opening the spreadsheet. The spreadsheet resides on a Synology network drive that has been listed in Excel as a Trusted Network Location. The option to forbid all macros to be run (except those in a Trusted Location) has always been enabled as well. It has all been working fine until a worker arrived at the office over the weekend to find 6 major circuit breakers tripped from some sort of power anomaly and all the computers and network equipment shut down. He switched the breakers back on and the network came back to life but assigned the Synology network drive a different IP address from what it was before the power anomaly. I came in today and found no one had access to the Synology drive and I assigned it the same IP it had before and made it static this time.
Okay, now later in the day I tried using the excel spreadsheet in question and noticed that none of the macros were executed when it opened, as it normally would. I removed the Trusted network location that was on the Synology drive and then added it again, hoping this would reset everything. It did not work. I have checked very carefully the macro and trusted location settings in the spreadsheet but it just won't execute the macros upon opening unless I set the macro settings to run any and all macros all the time. I can't leave it with this dangerous setting but cannot get it to run the macros when in the trusted location on the network Synology drive??? Did something change on the Synology when the power went out? Is there some hidden network change that I don't realize? I am pulling my hair out to get this very important spreadsheet program to work again.
Thanks for any help and/or advice you might be able to suggest. Please let me know if you need further information. Thank you!