cosmicsyzygy
08-27-2007, 08:06 AM
Hello
I am working an a productivity tracker that records transactions completed on a daily basis, giving a weekly and monthly total. It also calulates daily productivity numbers. On some days, there is no data and the cell remains blank. Unfortunately, this gives me the above error and that affects the monthly total. The spreadsheet is protected and allows data only for transaction completed. Is there a way to work around this without giving access?
Thanks in advance for any help.
CosmicSyzygy
I am working an a productivity tracker that records transactions completed on a daily basis, giving a weekly and monthly total. It also calulates daily productivity numbers. On some days, there is no data and the cell remains blank. Unfortunately, this gives me the above error and that affects the monthly total. The spreadsheet is protected and allows data only for transaction completed. Is there a way to work around this without giving access?
Thanks in advance for any help.
CosmicSyzygy