Re: $$Excel-Macros$$ How to update record in excel.

2011-04-21 Thread Jaideep Panchal
Hi JPK, You can simply select the raw that you want to update and Press F9. Regards, Jaideep - Original Message - From: "JPK" To: "MS EXCEL AND VBA MACROS" Sent: Wednesday, April 20, 2011 6:30 AM Subject: $$Excel-Macros$$ How to update record in excel. Hi, How to update the parti

Re: $$Excel-Macros$$ How to update record in excel.

2011-04-20 Thread mrinal saha
try this and paste it in code editor of the workbook you want to get refreshed automatically. Private Sub Workbook_Activate() Application.Calculation = xlCalculationAutomatic End Sub On Wed, Apr 20, 2011 at 6:30 AM, JPK wrote: > Hi, > > How to update the particular row in an excel when some

Re: $$Excel-Macros$$ How to update record in excel.

2011-04-20 Thread rajan verma
You can choose option "Always Create Backup " Available in Excel Save Dialog Box Under Tools Dropdown List at the time of Save. after it when you will save your file after any changes in then it will also save in Backup file.. On Wed, Apr 20, 2011 at 6:30 AM, JPK wrote: > Hi, > > How to update