General discussion

Locked

Excel file with macros won't open

By mcgrath.b ·
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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

What happens?

by JRod86 In reply to Excel file with macros wo ...

Do you get an error, or it just won't do anything?

Collapse -

Computer or Account?

by drivendesign In reply to Excel file with macros wo ...

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

Collapse -

excel->macros

by djameson In reply to Excel file with macros wo ...

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.

Collapse -

by mcgrath.b In reply to excel->macros

done that, not the issue

Collapse -

write protected?

by djameson In reply to

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

Collapse -

Verify Excel macro security level

by h.r.schmidt In reply to Excel file with macros wo ...

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.

Collapse -

Your rights on each PC

by dgh In reply to Excel file with macros wo ...

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

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums