Hello,
I have created a workbook and within that workbook I have created multiple sheets with each individual clients name. From the main sheet I have a list that I have created, and you would click on the client hyperlink name in the list and it would make you to that client perticular sheet.
That is working fine. After a couple of hundred sheet within the same workbook, I'm running into a problem now. The problem is that within each sheet, there are drop down list that are now not being able to display. These lists are repeated over and over again in each individual sheet, and I think I have reach a max on something.
On the original sheet I created the lists are working file. Once I copy that sheet any duplicated sheet will not be able to display the list. I have try change the list name, to making another sheet where the lists are location and nothing of my method are working.
Any help or suggestion is greatly appreciated.
Mike
I have created a workbook and within that workbook I have created multiple sheets with each individual clients name. From the main sheet I have a list that I have created, and you would click on the client hyperlink name in the list and it would make you to that client perticular sheet.
That is working fine. After a couple of hundred sheet within the same workbook, I'm running into a problem now. The problem is that within each sheet, there are drop down list that are now not being able to display. These lists are repeated over and over again in each individual sheet, and I think I have reach a max on something.
On the original sheet I created the lists are working file. Once I copy that sheet any duplicated sheet will not be able to display the list. I have try change the list name, to making another sheet where the lists are location and nothing of my method are working.
Any help or suggestion is greatly appreciated.
Mike
Last edited:
