cata2200
Board Regular
- Joined
- Jul 29, 2006
- Messages
- 60
Hello
Please assist me with the following problem:
I'm creating a wookbook with 12 worksheet with an iconic name as "YYYYMM - Monthly Occupancy", where YYYY = year and MM = month.
Lot of formulas are interconnected with the name of the working sheet and the sheet for the previous month (month(MM-1)).
Few cells are calculating date based on the worksheet name, but if I will move the "focus" to another sheet (typing anything) and return to the first one always I'm getting the the cells with "#value!" error. It is enough to double click in any (empty or not) cell to get the values refreshed.
Question: Is it there any solution to refresh the content of cells without this "doubleclick" operation?
Many thanks in advance,
Catalin
Please assist me with the following problem:
I'm creating a wookbook with 12 worksheet with an iconic name as "YYYYMM - Monthly Occupancy", where YYYY = year and MM = month.
Lot of formulas are interconnected with the name of the working sheet and the sheet for the previous month (month(MM-1)).
Few cells are calculating date based on the worksheet name, but if I will move the "focus" to another sheet (typing anything) and return to the first one always I'm getting the the cells with "#value!" error. It is enough to double click in any (empty or not) cell to get the values refreshed.
Question: Is it there any solution to refresh the content of cells without this "doubleclick" operation?
Many thanks in advance,
Catalin