Links - Why is this happening
 

We have 2 pc's, on one the code works fine, on the other it doesn't -
where should I check.

Spreadsheet 1 has a function written in VBA to return the number of
working days, based on a date supplied. It is a public function.
Spreadsheet 2 has a link to one (does not contain any vba) where it
referances a cell in spreadsheet 1 and attempts to call the working day
function.

This works fine on one PC, but not the other. Both appear to have the
same mappings and are supposed to be based on the company standard
build.

Also, if you open spreadsheet 1 and type in the working days function
(i.e. cell A1 = workingdays(now()), it will resolve itself.

It is really bugging me.


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile: http://www.excelforum.com/member.php...o&userid=15308
View this thread: http://www.excelforum.com/showthread...hreadid=572598

Links - Why is this happening
 

It's not clear what's not working.
Did you check Tools | Options then the Security tab to make sure that you're
allowed to run Macros?
do both sets of spreadsheets have the same names on both PC's?

It's hard to tell without knowing more. Do you have an error warning that
you could share with us?

David

"anthonyenglish" wrote:


We have 2 pc's, on one the code works fine, on the other it doesn't -
where should I check.

Spreadsheet 1 has a function written in VBA to return the number of
working days, based on a date supplied. It is a public function.
Spreadsheet 2 has a link to one (does not contain any vba) where it
referances a cell in spreadsheet 1 and attempts to call the working day
function.

This works fine on one PC, but not the other. Both appear to have the
same mappings and are supposed to be based on the company standard
build.

Also, if you open spreadsheet 1 and type in the working days function
(i.e. cell A1 = workingdays(now()), it will resolve itself.

It is really bugging me.


--
anthonyenglish
------------------------------------------------------------------------
anthonyenglish's Profile: http://www.excelforum.com/member.php...o&userid=15308
View this thread: http://www.excelforum.com/showthread...hreadid=572598