iainmartin100
New Member
- Joined
- Mar 9, 2011
- Messages
- 43
Hi, I'm hoping someone has a simple solution for this question.
I have a fairly heavy 2003 excel file which is set to manual cacluation, when I want the document to update I have a macro which simply does a full recalc of the workbook or sheet depending on which button I push.
On a couple of tabs within the workbook I have some graphs but these dont seem to pick up the changes, how would I include graphs to be updated within the macro?
p.s. there are many tabs within the document with only a few containing graphs, each tab calls the same macro's [either full workbook recalc or worksheet so inclding the chart name in the marco is probably not going to work unless I write individual macros for all tabs]
Any help would be great, many thanks
I have a fairly heavy 2003 excel file which is set to manual cacluation, when I want the document to update I have a macro which simply does a full recalc of the workbook or sheet depending on which button I push.
On a couple of tabs within the workbook I have some graphs but these dont seem to pick up the changes, how would I include graphs to be updated within the macro?
p.s. there are many tabs within the document with only a few containing graphs, each tab calls the same macro's [either full workbook recalc or worksheet so inclding the chart name in the marco is probably not going to work unless I write individual macros for all tabs]
Any help would be great, many thanks