|
-
Oct 4th, 2004, 06:36 AM
#1
Thread Starter
New Member
Cell containing Function Keeps Changing
I have a column of cells, each cell contains the same function -- the function takes values from three cells and returns a value. The problem is this: after several seconds, the values in the cells all change -- sometimes to another number, sometimes to zero, sometimes they put out the #VALUE thingee... When the cells change, they all seem to be changing similarly... If it matters, the Function in the cells calls upon other functions within that function to aid with the calculation. The changing of values is occuring when the spreadsheets automatically calculates (the workbook relies on live feed financial market data, and therefore cannot be left in "Manual"...
This is my first posting -- Thanks in advance to all for your time and help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|