Hi guys:
I have a workbook with 16 separate, named worksheets. One of the worksheets references the first 14 others by using a simple list off-screen in the AD column. I have a MATCH formula which uses the names of the worksheets from the list to identify a name and then "scratch" it off on the worksheet that has the named list.
My problem is, I need to change three of the worksheet names. I went ahead and changed the names on the three worksheets and that worked fine. But, everytime I try to go to the worksheet that has the list of worksheet names, after I click it stalls for a second, and then crashes. I reload it and everything and it works fine with the original names, but it just won't let me change the names of the worksheets. This is a big problem for the functionality of my workbook.
Thanks much.
I have a workbook with 16 separate, named worksheets. One of the worksheets references the first 14 others by using a simple list off-screen in the AD column. I have a MATCH formula which uses the names of the worksheets from the list to identify a name and then "scratch" it off on the worksheet that has the named list.
My problem is, I need to change three of the worksheet names. I went ahead and changed the names on the three worksheets and that worked fine. But, everytime I try to go to the worksheet that has the list of worksheet names, after I click it stalls for a second, and then crashes. I reload it and everything and it works fine with the original names, but it just won't let me change the names of the worksheets. This is a big problem for the functionality of my workbook.
Thanks much.