troubleshooting Question

Xlsm file odd security setting when created in Excel 2003

Avatar of ElrondCT
ElrondCTFlag for United States of America asked on
Microsoft ExcelWindows 7
4 Comments1 Solution416 ViewsLast Modified:
I have an Excel macro which converts a .prn text file to a .xlsm macro-enabled spreadsheet.  On a Windows 7 Home Premium machine with the Office Compability Pack installed, running Excel 2003, the spreadsheet created has an odd security setting: in the Security tab of Properties for the file (viewed in Windows Explorer/My Computer), the group "Everyone" is missing. The result is that I cannot view the file when I connect from another, networked computer. I have other macros which convert .prn files to .xls spreadsheets, and they do show the Everyone group, with Full Control permission enabled.

Checking a bit more, I get the same behavior (no Everyone group) if I open a .xls spreadsheet and save it as either .xlsx or .xlsm. I also notice that the icon in the folder listing is slightly different; there's a gold padlock superimposed on the Excel icon. The padlock disappears if I create the Everyone group in the Security tab and give it Full Control.

I don't have this problem when I run the macro in Excel 2007 on another Windows 7 computer, but I have no way to verify whether it's something unusual in one of the computers, or a difference between Excel 2003 and 2007.

I can't see anything in the Excel options tabs that would seem to relate to this, though I may just not be looking in the right place. Any ideas on how to make these worksheets automatically visible & enabled to all in the Everyone group?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros