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
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 automati
