Hi all,
I came accross this today and found it rather strange. I was wondering if any of you have had the same problem and whether or not you were able to solve it?
I have a spreadsheet where several sheets link to a date (reporting month). The date is specified on a 'Control Tab'. When i amend the date on the 'Control Tab' the other sheets don't seem to recognise this and don't refresh.
Even when i go TOOLS-OPTIONS-CALCULATION and hit calc now (F9) the date doesn't change. the only way i have been able to refresh this is by double clicking in the cell which contains the link (='Control Tab'!$B$1) and then hitting enter.
The 'Control Tab' date is formatted dd/mm/yyyy and the linked date is formatted mmm/yy should that make a difference.
Cheers
I came accross this today and found it rather strange. I was wondering if any of you have had the same problem and whether or not you were able to solve it?
I have a spreadsheet where several sheets link to a date (reporting month). The date is specified on a 'Control Tab'. When i amend the date on the 'Control Tab' the other sheets don't seem to recognise this and don't refresh.
Even when i go TOOLS-OPTIONS-CALCULATION and hit calc now (F9) the date doesn't change. the only way i have been able to refresh this is by double clicking in the cell which contains the link (='Control Tab'!$B$1) and then hitting enter.
The 'Control Tab' date is formatted dd/mm/yyyy and the linked date is formatted mmm/yy should that make a difference.
Cheers