If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula Values not Updating
Hello,
I have a multisheet spreadsheet that keeps track of costs on jobs that extend over multiple days (a worksheet for each day). This is something that our group does often so I created a macro that helps the user by adding a sheet with formulas in place that adds the current day's totals with the previous day's cumulative totals. Sometimes the value of some of the cells with formulas won’t update automatically. By clicking in the cell, I can see that the formula is correct. However, in order to make it update, I have to select the cell, then put my cursor in the formula bar and press the enter key. This only happens “sometimes” and I can’t seem to recreate the issue. It’s an easy enough issue to fix when I know that the problem is there but since it doesn’t happen all of the time, I’ll only know that the issue exists if I happen to stumble across it. Therefore, I don’t know if I can trust my data or not. Any ideas? Thanks |
#2
|
|||
|
|||
Formula Values not Updating
Have you try to recalculate (worksheet.calculateful I guess) after macro task
ended? "dcornett63" wrote: Hello, I have a multisheet spreadsheet that keeps track of costs on jobs that extend over multiple days (a worksheet for each day). This is something that our group does often so I created a macro that helps the user by adding a sheet with formulas in place that adds the current day's totals with the previous day's cumulative totals. Sometimes the value of some of the cells with formulas won’t update automatically. By clicking in the cell, I can see that the formula is correct. However, in order to make it update, I have to select the cell, then put my cursor in the formula bar and press the enter key. This only happens “sometimes” and I can’t seem to recreate the issue. It’s an easy enough issue to fix when I know that the problem is there but since it doesn’t happen all of the time, I’ll only know that the issue exists if I happen to stumble across it. Therefore, I don’t know if I can trust my data or not. Any ideas? Thanks |
Thread Tools | |
Display Modes | |
|
|