Formulas the preform calculations on other workbooks

[Lsxtrkiller]

I have a large number of formula on a workbook that preforms calculations, lookups, ect. on about 12 other workbooks. However these formula only update when(I open the workbook or when I open the workbook that the calculations are based on.) Is there a way to make these update regularly?

I have a vba solution for my problem to simply open a bunch of workbooks so the calculations can update but I want to avoid having to open the workbooks... possible in excel?

[FDibbins]

Is there a way to make these update regularly?

depending on the formula you are using, unlikely - there are a few functions that do not work on closed workbooks, but there may be others you could use instead.

what formulas are you using?

[nimrod]

If a book is never opened why would it matter if the values are updated ??
Excel has specific times calculations are updated , e.g. closing workbook , opening workbook , saving workbook and updating workbook.
If all workbooks with formula were constantly polling to see if link workbooks were updated your PC would have a tremendous overhead on it's CPU.

[FDibbins]

Excel has specific times calculations are updated

Not so. Any links to other workbooks (that are open) are updated any time a change is made on the other workbook
(try it and see )

[Lsxtrkiller]

Well the workbooks that are being calculated upon are being used by other users.

Obviously the formula would only update when the workbooks are saved by the active user.

I am using sumif, countif, sumifs, countifs, tan, cos, round, transpose ect.

I don't need them to update constantly just periodically would be fine but unless I close or open they don't update.

I found a vba script to force an update but I would rather not have an ontime macro running.