C
chits
i have an excel sheet where i am using 'NETWORKINGDAYS' formula to compute
the effort variance. I have this file in a shared directory where i have
multiple users accessing this file. To get the correct value for (Net Working
days) formula, i have enabled Tools - Add-Ins - Analysis Toolpack option on
my machine. i can see the output value of this formula correctly after
enabling the above option.
But if someone else opens this file, they cannot see the formula active ..
they get to see "Value!" in that cell instead of the figure. they have to
manually enable the analysis toolpack option.
Can someone suggest me the workaround if i can write a VBA macro to get this
value automatically visible whenever anyone opens this file directly from
server or if this file is sent as an attachment, they can view the actual
figures without manually enabling the option?..
Thanks,
Chitra
the effort variance. I have this file in a shared directory where i have
multiple users accessing this file. To get the correct value for (Net Working
days) formula, i have enabled Tools - Add-Ins - Analysis Toolpack option on
my machine. i can see the output value of this formula correctly after
enabling the above option.
But if someone else opens this file, they cannot see the formula active ..
they get to see "Value!" in that cell instead of the figure. they have to
manually enable the analysis toolpack option.
Can someone suggest me the workaround if i can write a VBA macro to get this
value automatically visible whenever anyone opens this file directly from
server or if this file is sent as an attachment, they can view the actual
figures without manually enabling the option?..
Thanks,
Chitra