You must have a really fast computer, mine took several minutes to calculate after having pressed F9 (this was on the zipped workbook). I am glad to hear that the spreadsheet is now working as desired. Reading the second article more closely ver 2013 offers several options for manual calculation in the last paragraph. At any rate if the solutions provided are satisfactory please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.