Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ACTIVATE CELLS
I have large matrix with forumlas that i want to copy into 65 different excel
files. The formulas pick up new data in the destination file and return new results. However, I need to use the F2 key and ENTER on each cell before the formulas recalculate. I have a 25X20 matrix and this process takes a long time. Is there a way to automatically activate the entire spreadsheet or range of cells? |
#2
|
|||
|
|||
<Tools <Options <Calculation tab,
And make sure that "Automatic" *is* checked. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mdeanda" wrote in message ... I have large matrix with forumlas that i want to copy into 65 different excel files. The formulas pick up new data in the destination file and return new results. However, I need to use the F2 key and ENTER on each cell before the formulas recalculate. I have a 25X20 matrix and this process takes a long time. Is there a way to automatically activate the entire spreadsheet or range of cells? |
#3
|
|||
|
|||
Right click the tab for the sheet and click view code, copy this in
Private Sub Worksheet_Activate() Calculate End Sub Alternatively press Alt F9 to recalculate You may also want to check ToolOptionsCalculations to make sure it is set to automatic. -- _______________________ Naz, London "mdeanda" wrote: I have large matrix with forumlas that i want to copy into 65 different excel files. The formulas pick up new data in the destination file and return new results. However, I need to use the F2 key and ENTER on each cell before the formulas recalculate. I have a 25X20 matrix and this process takes a long time. Is there a way to automatically activate the entire spreadsheet or range of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |