AUTO Updating

[UnsolvedCoding]

So on this project I have been working on I am doing final testing and started having a new issue with the formulas placed into the worksheets not updating. I can't figure out why they won't update and have tried a fairly wide range of solutions including Application.Update, ThisWorkbook.Sheets("Sheet1").Cells.Calculate, ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources, Application.Volatile and a few variations of application.calculate.

In the end the formulas won't update without selecting them and hitting enter. The users won't be able to see the information collected from different sheets or the updated information if this problem isn't resolved and that will mean it comes back to me for updates to get the formulas to work.

What can I do to resolve this issue?



It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.

 

[SkipVought]

Hi,

PLEASE use the Code formatting, rather than stringing statements together.

In the past, I've had to calculate specific cells or ranges via code. I'd NAME those ranges and...

'
   [MyRange].Calculate

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}