Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting default number of iterations within ALL my excel spreadshe
I wish the default number of iterations within ALL my excel spreadsheets to
be set at the maximum number viz. 9999. Presently, whenever saved spreadsheets are recalled they have reverted to the default of 100 iterations irrespective of the fact that at the time of saving them the iteration frequency level had been changed to 9999. Please, can anyone help! Thanks Gavin Bulman |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting default number of iterations within ALL my excel spreadshe
Gavin,
Put this line into the workbook open event of all your workbooks: Application.MaxIterations = 9999 HTH, Bernie MS Excel MVP "Gavin Bulman" wrote in message ... I wish the default number of iterations within ALL my excel spreadsheets to be set at the maximum number viz. 9999. Presently, whenever saved spreadsheets are recalled they have reverted to the default of 100 iterations irrespective of the fact that at the time of saving them the iteration frequency level had been changed to 9999. Please, can anyone help! Thanks Gavin Bulman |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting default number of iterations within ALL my excel sprea
Bernie
Thanks so much for the response. I possibly should have mentioned that I am working on Excel 2000 €“ does that make a difference to your suggested action to achieve my aim of having Excel always perform maximum number of iterations when I open any excel spreadsheet? If not then I need your help again as I don't know where to " Put this line into the workbook open event of all your workbooks"!!!! Please help! Thanks Gavin "Bernie Deitrick" wrote: Gavin, Put this line into the workbook open event of all your workbooks: Application.MaxIterations = 9999 HTH, Bernie MS Excel MVP "Gavin Bulman" wrote in message ... I wish the default number of iterations within ALL my excel spreadsheets to be set at the maximum number viz. 9999. Presently, whenever saved spreadsheets are recalled they have reverted to the default of 100 iterations irrespective of the fact that at the time of saving them the iteration frequency level had been changed to 9999. Please, can anyone help! Thanks Gavin Bulman |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting default number of iterations within ALL my excel sprea
Bernie
Thanks so much for the response. I possibly should have mentioned that I am working on Excel 2000 €“ does that make a difference to your suggested action to achieve my aim of having Excel always perform maximum number of iterations when I open any excel spreadsheet? If not then I need your help again as I don't know where to " Put this line into the workbook open event of all your workbooks"!!!! Please help! Thanks Gavin "Bernie Deitrick" wrote: Gavin, Put this line into the workbook open event of all your workbooks: Application.MaxIterations = 9999 HTH, Bernie MS Excel MVP "Gavin Bulman" wrote in message ... I wish the default number of iterations within ALL my excel spreadsheets to be set at the maximum number viz. 9999. Presently, whenever saved spreadsheets are recalled they have reverted to the default of 100 iterations irrespective of the fact that at the time of saving them the iteration frequency level had been changed to 9999. Please, can anyone help! Thanks Gavin Bulman |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting default number of iterations within ALL my excel sprea
Gavin,
Visit http://www.mvps.org/dmcritchie/excel/event.htm for background on using events. You want to use the Thisworkbook objects workbook_open event - save the file as your Book.xlt and other .xlt files and Excel will use that anytime you create a new workbook. You will need to add it to each of the existing workbooks that you want to have this functionality. HTH, Bernie MS Excel MVP "Gavin Bulman" wrote in message ... Bernie Thanks so much for the response. I possibly should have mentioned that I am working on Excel 2000 - does that make a difference to your suggested action to achieve my aim of having Excel always perform maximum number of iterations when I open any excel spreadsheet? If not then I need your help again as I don't know where to " Put this line into the workbook open event of all your workbooks"!!!! Please help! Thanks Gavin "Bernie Deitrick" wrote: Gavin, Put this line into the workbook open event of all your workbooks: Application.MaxIterations = 9999 HTH, Bernie MS Excel MVP "Gavin Bulman" wrote in message ... I wish the default number of iterations within ALL my excel spreadsheets to be set at the maximum number viz. 9999. Presently, whenever saved spreadsheets are recalled they have reverted to the default of 100 iterations irrespective of the fact that at the time of saving them the iteration frequency level had been changed to 9999. Please, can anyone help! Thanks Gavin Bulman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel default number format problem | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How do I change the default number format in Excel? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |