Using Excel 2000, I created four individual workbooks. It was determined that all four of these reports should be combined into one workbook. I copied this information into one workbook containing four worksheets, one for each of the individual reports.
After this copy/paste was done, the new workbook was looking for information from the four individual reports. I removed all of the external references and deleted the four reports. Everything worked fine.
There is a variety of information contained in the workbook, including the NETWORKDAYS calculation. Once I created the new workbook, another user added three more worksheets to the workbook, and for one of the worksheets, she copied the NETWORKDAYS formula from my sheet to her sheet.
When I open and view the workbook, everything looks fine. However, whenever ANYONE else makes a change to information related to the NETWORKDAYS formula (such as changing a date), the calculations having to do with the NETWORKDAYS formula appear with the #NAME? error. Once this error appears, there is nothing that can be done to correct it - we have tried re-keying the formula into the spreadsheet, changing data, etc., but nothing works.
The frustrating thing is that I don't even see the errors on my PC - all of the calculations are correct. To fix the problem for everyone else, all I have to do is open the workbook, save it and close it - then everyone sees the correct information.
Has anyone heard of this before? It must be stemming from a setting on my PC, but I don't know what else to check. Any suggestions would be appreciated!
After this copy/paste was done, the new workbook was looking for information from the four individual reports. I removed all of the external references and deleted the four reports. Everything worked fine.
There is a variety of information contained in the workbook, including the NETWORKDAYS calculation. Once I created the new workbook, another user added three more worksheets to the workbook, and for one of the worksheets, she copied the NETWORKDAYS formula from my sheet to her sheet.
When I open and view the workbook, everything looks fine. However, whenever ANYONE else makes a change to information related to the NETWORKDAYS formula (such as changing a date), the calculations having to do with the NETWORKDAYS formula appear with the #NAME? error. Once this error appears, there is nothing that can be done to correct it - we have tried re-keying the formula into the spreadsheet, changing data, etc., but nothing works.
The frustrating thing is that I don't even see the errors on my PC - all of the calculations are correct. To fix the problem for everyone else, all I have to do is open the workbook, save it and close it - then everyone sees the correct information.
Has anyone heard of this before? It must be stemming from a setting on my PC, but I don't know what else to check. Any suggestions would be appreciated!
