LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WKH WKH is offline
external usenet poster
 
Posts: 5
Default Formulas that calculate to errors on one computer but not on anoth

I am using an excel file that I've placed on a shared server folder. I
created the original file, Three other people have access to the file. When
information is enter into the cells from two of the three they get an $names
error message in the formualted cells. But, if I open it and look at the
cells they changed the caculation they entered appears correct on my
computer. The obvious thought is that we're using different versions of excel
or updates but we've check that and all on the same page. The physical
computers are a bit older, but I'm not sure that should effect Excel. We've
also made sure the box is checked to accept labels in the formulas. Here's a
sampling of the formula =IF(F6="",(""),IF(F6="AD or
Email",(WORKDAY(L6,-7,AB6:AN6)). This should roll out a date when you enter
"AD or Email" into cell F6 but the folks with the problems are getting
$names, while I'm seeing the date ( along with one of the other folks ).

Any thoughts or help would be appreciated.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inexplicable VBA errors in formulas Dallman Ross Excel Discussion (Misc queries) 7 August 11th 07 12:32 AM
remove links when pasteing formulas from one workbook to anoth Roger Excel Worksheet Functions 1 January 19th 07 08:21 PM
What is the function to calculate standard errors of the mean? Steph Excel Worksheet Functions 2 July 17th 06 02:44 PM
Handling errors in formulas (how annoying are they!) anon90210 Excel Discussion (Misc queries) 1 January 17th 05 01:26 PM
Errors in copying formulas Frequent_User Excel Discussion (Misc queries) 1 December 12th 04 12:00 AM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"