Mark,

Check the path of the referenced worksheet(s) in the formula(s). They may
be pointing to a worksheet(s) in another workbook(s).

"Mark Jackson" wrote:

Hello,

I created a workbook with formulas that work with links to other worksheets.
When I copied it to a disk and saved it to my work computer the formulas do
not work. Here is one of the formulas: =SUM{(('Procurement Gateway
'!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement
Gateway '!J3:J220))} This works on the disk that I saved it on, but does not
work on my compter at work. I get this error: #VALUE! What am I doing
wrong? Any help is appreciated.

Thanks!

Mark Jackson