Caculating selected cells

[Need_Help_Now]

Hello everyone!

I have a huge spreadsheet, about 450,000 rows of data with multiple formulas and pivot tables, so anytime I want to calculate, it takes a very long time.

I just want to recalculate some of the formulas, so is it possible to select the specific cells with the required formulas and just calcualte those cells?

Thanks in advance.

 

[Richard Schollar]

Yes: select the cells and then go Ctrl+H to open up the edit dialog box and use Find = and Replace = and hit to Replace All.

 

[Richard Schollar]

You could, alternatively, select the cells and open up the VBE (Alt+F11), open up the Immediate Window (Ctrl+G) and then type in:

Selection.Calculate

and press Enter.

 

[Need_Help_Now]

Thanks, will probably go for the vb option.