Sep 17 2020 08:11 AM
Hi,
A third party Oracle application creates Microsoft Excel 97-2003 Worksheet (.xls) with macros in it (but not with xlsm extension) but when a user with Office 365 accesses the file in comes up Access Denied. Contact your Administrator. I have checked the rights of the folder where the files reside on the network and the user has all rights except full control. The Trusted file locations in Excel has the path where the files are located. The trusted documents is set to "Allow documents from Network Locations" is enabled.
When I copy the file to the desktop it is accessible. If I save the file as an xlsx everyone can open it.
Older versions of Excel can open the file without issues in the same locations.
Can anyone advise how we can resolve this issue?
Thanks for taking the time to read this question.
Alastair MacFarlane
Sep 17 2020 09:09 AM
Feb 10 2021 04:20 AM
Did you manage to find a solution to this problem. We have it on two computers (out of a 100) with both doc. and .xls files.