Prev: How do I remove a Calculated Field from the Pivot Table field
Next: Excel file size limitation
From: jkcates on 9 Apr 2010 14:23
Hello,
I am working with a 3rd part template in excel that has fill in fields. The
issue I am having is that, the file works fine on my computer, but on other
computers in the office, the fields are not showing up.
The versions of excel are identical, 2003, and the OS are all xp. Could this
be a macro issue? Or a security setting that needs to be changed on other
workers computers in order to run the file with the fileds?

Thank You
From: Luke M on 9 Apr 2010 14:27
It could be a secutiry issue, if the template uses macros and the other
users have their Tools - Macro - Security setting too high.

--
Best Regards,

Luke M
"jkcates" <jkcates(a)discussions.microsoft.com> wrote in message
news:36609D9B-AFDA-474B-B2F2-B4C2236D781E(a)microsoft.com...
> Hello,
> I am working with a 3rd part template in excel that has fill in fields.
> The
> issue I am having is that, the file works fine on my computer, but on
> other
> computers in the office, the fields are not showing up.
> The versions of excel are identical, 2003, and the OS are all xp. Could
> this
> be a macro issue? Or a security setting that needs to be changed on other
> workers computers in order to run the file with the fileds?
>
> Thank You


From: JLatham on 10 Apr 2010 01:04
I agree with Luke M on the possible lock-out of macros on the other systems.

My 2-cents about macro security in 2003: have the users set it to "Medium"
where they get an alert that macros are present and an opportunity to enable
or disable them. Especially if there's any chance they may use Excel files
from outside of your organization. The decision to enable/disable should be
based on knowledge and trust of the source of the file. I run my own systems
at home at that level, even though probably 95% of .xls files I open were
created by me and have code in them; I consider the one extra click required
to enable the macros good protection against the odd book I may get from
somewhere that has macros in it that I may want to examine before allowing
them to run on my system. Setting the security level to the ultra-convenient
"LOW" is just unsafe, especially in a professional, business environment.

"Luke M" wrote:

> It could be a secutiry issue, if the template uses macros and the other
> users have their Tools - Macro - Security setting too high.
>
> --
> Best Regards,
>
> Luke M
> "jkcates" <jkcates(a)discussions.microsoft.com> wrote in message
> news:36609D9B-AFDA-474B-B2F2-B4C2236D781E(a)microsoft.com...
> > Hello,
> > I am working with a 3rd part template in excel that has fill in fields.
> > The
> > issue I am having is that, the file works fine on my computer, but on
> > other
> > computers in the office, the fields are not showing up.
> > The versions of excel are identical, 2003, and the OS are all xp. Could
> > this
> > be a macro issue? Or a security setting that needs to be changed on other
> > workers computers in order to run the file with the fileds?
> >
> > Thank You
>
>
> .
>
 | 
Pages: 1
Prev: How do I remove a Calculated Field from the Pivot Table field
Next: Excel file size limitation