Re: $$Excel-Macros$$ Need a macro to update charts automatically

2011-12-17 Thread dguillett1
Please explain your need Don Guillett SalesAid Software dguille...@gmail.com From: Atul vishwakarma Sent: Thursday, December 15, 2011 8:29 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Need a macro to update charts automatically Hi Friends, I need a macro to update charts

Re: $$Excel-Macros$$ Need a macro to update charts automatically

2011-12-19 Thread NOORAIN ANSARI
Dear Atul, Please use below code to update Chart Automatic.. * Private Sub Workbook_Open() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.Calculate Next Set wks = Nothing End Sub* also visit on below web link.. http://spreadsheetpage.com/index.php/tip/upda