Function won't calculate until I click in Cell and press Enter

G

Guest

Hi all,

I created my own function which does work correctly. After doing some work,
the cells using this function are displaying #Value. Since the function did
work before and I did not change anything I was a bit worried.

Nothing did work until I just clicked in one cell containing the function
and pressed enter, and it works. Miracle! Since I don't like to click
hundreds of cells I would appreciate, if any of you guys encountered this
error before.

I am using Excel 2003 11.8134.8132 SP2
 
G

Guest

By clicking the cell and touching ENTER, your are forcing the function to
re-calculate.


Run this tiny macro to force complete re-calculation:

Sub kick_it()
Application.CalculateFullRebuild
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy excel cell to webform (search box) and press enter 10
formula won't calculate unless I click cell 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Function can not read cell value properly without enter 2
Formulas not calculating when values are entered. 1
function to re-calculate when cell format (colour) changes 1
Cell reference in User Defined Function. 19
why does formula not work until I clear referenced cell ?? 3

Top