Hi!
I've got the following problem with Excel 2003: I've got an Excel sheet which contains various cell links to sheets which aren't (yet) existing. Of course Excel complains on loading the workbook about the invalid references, but that's not the problem:
Now a macro generates the missing sheets, so all the links in the first sheet should be working now. But obviously Excel doesn't update the cells and "ignores" the newly generated sheets.
Solution (though not really applicable): Just click on the cell which contains the link, then click in the formula. Now _without changing anything_ hit enter. And suddenly, the cell link is working.
Since I can't do this manually with every formula each time: Any idea how to solve this?
Thanks!
Gereon
I've got the following problem with Excel 2003: I've got an Excel sheet which contains various cell links to sheets which aren't (yet) existing. Of course Excel complains on loading the workbook about the invalid references, but that's not the problem:
Now a macro generates the missing sheets, so all the links in the first sheet should be working now. But obviously Excel doesn't update the cells and "ignores" the newly generated sheets.
Solution (though not really applicable): Just click on the cell which contains the link, then click in the formula. Now _without changing anything_ hit enter. And suddenly, the cell link is working.
Since I can't do this manually with every formula each time: Any idea how to solve this?
Thanks!
Gereon
