When i open an autocad drawing file that has a linked excel file in it, it will open the linked excel file as a hidden workbook, so i have to go to view in excel and manually unhide all of them. I make panel schedules in excel and then link them into autocad (paste special), so if i have a cad file with 7 panel schedules, when i open that cad drawing, it opens all 7 excel files as hidden and its very annoying as to why it does this and i have yet to find a solution. This is especially annoying because if a coworker of mine opens the drawing, it will open the excel file as hidden without their knowledge of it being open, so then when i try to open it, it says someone is in it, and its hard to figure out who is in the excel file.
I kinda found a solution but i dont like it. if i open up the cad file that has the excel sheet in it, type OLELINKS command, select the link, and hit open source, it will open the excel link, i can save, close both, then if i re-open the cad file with the link in it, it wont open the excel file as hidden (it wont open it at all). But if i open the cad file, and then go to open the excel file through file explorer (not through OLELINKS), save both, close both, and open the cad file, it will go back to opening the excel file as hidden. Any solutions to this?
