Latest vlc version. Excel stores dates internally as serial numbers, which are floating-point numbers. The integer portion represents the number of days since January 1, 1900 in Windows, and the number of days since January 1, 1904 on a Mac, where January 1 is equal to one.

I have a large spreadsheet with a lot of built-in circular references. I have built in VBA code to set to manual and iterative calculation on opening and also code to force a calculation on workbook open after I set to iterative calculation. However, it appears that the workbook tries to calculate before even running this VBA code on opening, such that if the workbook is already set to automatic calculation with no iterative calculation, it runs the workbook and then crashes because of the circular references. I know I can set my own Application settings to always have iterative calculation, but this workbook is shared with others who may not have those same Application settings. Microsoft office for mac os 10.9. Is there a way to halt the calculation on opening until the code has set the application to iterative calculation.

In a blank.xlsm file, in the workbook open event, put in this code Private Sub Workbook_Open() Application.calculation = xlCalculationManual ' Add code to open the real workbook ' --------- End Sub Since the calculations will be driven by whether or not the last opened workbook is manual or automatic, the above code will have to be put into a Caller workbook (shown above). This caller workbook, upon opening, will first disable calculations and then pull up your workbook which will be guaranteed to have manual calculation mode. Also, in the required workbook (the one with circular references), The OnOpen event should trigger a Close of the caller workbook without saving. That way the process is transparent to the user and s/he only opens the Caller book. HNK, I see what you are saying and that is definitely on the right track. Does that solution though require that the end user be on the same network where my required workbook are saved? My intention (not ideal but the way things are done) is that the files are shared by email as there are updates, so I am trying to think through how to share the caller workbook via email and also still have it be able to open the required workbook without sending two separate files.

Sorry for my ignorance but this is very helpful to me! – Jul 2 '14 at 17:03 •.