I have created a master workbook for my records and have saved a copy to a shared drive for others to access. It is not saved as a shared workbook, although I thought about doing it that way.
Anyway, whenever I enter data into the sheet it looks great on my workstation, however when someone else pulls it up on their machine the formulas give a "#NAME?" error. I have tried auditing the errors with no luck. I am thinking it may be individual settings on each computer, but no one is able to see the results of the formulas except me. I have tried three other computers in our office. I have also protected the worksheet. Would this have any bearing on seeing the formula calculations?
I also have some VBA code in this worksheet, but I "Enable Macros" when I open the sheet. That code is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count<> 1 _
Or Target.Row<= 2 Then Exit Sub
If Intersect(Target, [D:H]) Is Nothing Then Exit Sub
If (Target - Int(Target))< TimeSerial(8, 0, 0) Then Target = Target + 0.5
End Sub
I have included a sample of the data below.
Any suggestions would be greatly appreciated.
Anyway, whenever I enter data into the sheet it looks great on my workstation, however when someone else pulls it up on their machine the formulas give a "#NAME?" error. I have tried auditing the errors with no luck. I am thinking it may be individual settings on each computer, but no one is able to see the results of the formulas except me. I have tried three other computers in our office. I have also protected the worksheet. Would this have any bearing on seeing the formula calculations?
I also have some VBA code in this worksheet, but I "Enable Macros" when I open the sheet. That code is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count<> 1 _
Or Target.Row<= 2 Then Exit Sub
If Intersect(Target, [D:H]) Is Nothing Then Exit Sub
If (Target - Int(Target))< TimeSerial(8, 0, 0) Then Target = Target + 0.5
End Sub
I have included a sample of the data below.
| ETrack Jim.xls | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | EstimateTracking | |||||||||||||
| 2 | Customer | Sales/CSR | Estimate# | E-maildate/time | Printoutdate/time | Duedate/time | Startdate/time | Date/Timedelivered | Notes | RequestedTurnTime | ActualTurnTime | ActualProd.Time | ||
| 3 | TYCO | Smith | 1234 | 1/21/049:00AM | 1/21/049:30AM | 1/22/0412:00PM | 1/21/0410:00AM | 1/22/0411:00AM | #NAME? | #NAME? | #NAME? | |||
1-26 to 1-30 | ||||||||||||||
Any suggestions would be greatly appreciated.
