Windows Forum

Ask something
Discussion Locked

Excel file with macros won't open

0 helpful
7 replies

by mcgrath.b

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I am dealing with a problem where there are 4 PCs, each with this excel file with macros. It will only open on one of the PCs. Each PC has the same verision of office (2k), xp pro sp2, mcafee virus scan.

Any ideas why this file will open on one pc, and not the rest?

7 replies

by drivendesign

Does it not open on that computer or the users account at that workstation? Is it a networked file or on the persons HDD?

by djameson

it's excel... change your security level on the app. tools->macros->security set it to medium so you will be prompted to run the macros when you opent the doc.

by djameson

make sure the xls file isn't write protected. with Macros sometimes this will cause it to fail.

by h.r.schmidt

If Excel has a macro security level of HIGH, macros will not open. Within Excel click on Tools\Macro\Security and set the security level to medium (safer) or low.

by dgh

Do you login on each PC? Do you have the same rights on each PC?

This discussion is closed to new replies.