Access Denied to Microsoft Excel 97-2003 Worksheet (.xls) network File

%3CLINGO-SUB%20id%3D%22lingo-sub-1679282%22%20slang%3D%22en-US%22%3EAccess%20Denied%20to%20Microsoft%20Excel%2097-2003%20Worksheet%20(.xls)%20network%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679282%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20third%20party%20Oracle%20application%20creates%26nbsp%3B%3CFONT%3EMicrosoft%20Excel%2097-2003%20Worksheet%20(.xls)%3C%2FFONT%3E%20with%20macros%20in%20it%20(but%20not%20with%20xlsm%20extension)%20but%20when%20a%20user%20with%20Office%20365%20accesses%20the%20file%20in%20comes%20up%20Access%20Denied.%20Contact%20your%20Administrator.%20I%20have%20checked%20the%20rights%20of%20the%20folder%20where%20the%20files%20reside%20on%20the%20network%20and%20the%20user%20has%20all%20rights%20except%20full%20control.%20The%20Trusted%20file%20locations%20in%20Excel%20has%20the%20path%20where%20the%20files%20are%20located.%20The%20trusted%20documents%20is%20set%20to%20%22Allow%20documents%20from%20Network%20Locations%22%20is%20enabled.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20copy%20the%20file%20to%20the%20desktop%20it%20is%20accessible.%20If%20I%20save%20the%20file%20as%20an%20xlsx%20everyone%20can%20open%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOlder%20versions%20of%20Excel%20can%20open%20the%20file%20without%20issues%20in%20the%20same%20locations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20advise%20how%20we%20can%20resolve%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20taking%20the%20time%20to%20read%20this%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlastair%20MacFarlane%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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

1 Reply
Highlighted
More Information: Thanks for the reply. I will check it out tomorrow (UK Time), but I would add that the VBA code does not compile (debug + compile VBA Project). It is a standard spreadsheet of 100 sheets (eacha different Cost Centre and in each sheet there is an itemised listing of expenditure in this month against a Cost Centre. The spreadsheet is created by Oracle e-Financials and has code in it that does not compile. Does this help in any way? All I could do is upload a couple of redacted images of the spreadsheet but I can only think that it is a compatibility issue between the version of the file, it not being an xlsm and Office 365. This is then counter-intuitive with it being copied to the desktop and being accessible. Could it even be AD corruption of path and nothing at all to do with Office at all? But if the user logs into a pc with an older version of Office they can open the file! I am totally confused. Thanks for taking the time to reply. Alastair