Have noticed that on the project management dashboard that the GANTT chart disappears when you reopen a saved file. If I click edit hyperlink and click OK without doing anything, it reappears until I next close the app. Any ideas what's going wrong?
[edit] - I see it's a picture link, is there any code for refreshing once the programme is reopened?
I'm using excel 2007 on win7.
Solution:
Right, having had a good google around, I've found this not a unique problem with objects, you only need to hit F9 to get the page to refresh after opening.
Simply put the code:
in the 'ThisActiveWorkbook' and when the excel sheet opens, assuming you've saved it in excel macro enabled file and macros on the person receiving the sheet has it enabled as well it'll work. Lovely stuff.
[edit] - I see it's a picture link, is there any code for refreshing once the programme is reopened?
I'm using excel 2007 on win7.
Solution:
Right, having had a good google around, I've found this not a unique problem with objects, you only need to hit F9 to get the page to refresh after opening.
Simply put the code:
in the 'ThisActiveWorkbook' and when the excel sheet opens, assuming you've saved it in excel macro enabled file and macros on the person receiving the sheet has it enabled as well it'll work. Lovely stuff.