Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
remove links when pasteing formulas from one workbook to anoth | Excel Worksheet Functions | |||
What is the function to calculate standard errors of the mean? | Excel Worksheet Functions | |||
Handling errors in formulas (how annoying are they!) | Excel Discussion (Misc queries) | |||
Errors in copying formulas | Excel Discussion (Misc queries) |