Hi All -
I seem to have a very weird problem. I am various workbooks that I update every few months. Each time I update, I essentially use the same tabs in each workbook, just with different numbers and have to insert new tabs every now and then.
Recently, I have been having issues with one tab in particular. To make explaining easier, lets call this tab "Current."
Whenever I insert a new worksheet and try to link "Current" to a number in the new worksheet, Excel gives me an error and crashes. However, if I pick any other tab and try to link it to the new worksheet, OR try to link "Current" to another existing tab, its fine.
This problem happens no matter what workbook I am in and only with the specific tab. Every "Current" tab in every workbook cannot seem to link to newly inserted worksheets. The only thing in common that the "Current" tab has in each workbook is essentially the formatting.
If anyone has any suggestions, Id greatly appreciate it!!
I seem to have a very weird problem. I am various workbooks that I update every few months. Each time I update, I essentially use the same tabs in each workbook, just with different numbers and have to insert new tabs every now and then.
Recently, I have been having issues with one tab in particular. To make explaining easier, lets call this tab "Current."
Whenever I insert a new worksheet and try to link "Current" to a number in the new worksheet, Excel gives me an error and crashes. However, if I pick any other tab and try to link it to the new worksheet, OR try to link "Current" to another existing tab, its fine.
This problem happens no matter what workbook I am in and only with the specific tab. Every "Current" tab in every workbook cannot seem to link to newly inserted worksheets. The only thing in common that the "Current" tab has in each workbook is essentially the formatting.
If anyone has any suggestions, Id greatly appreciate it!!