Community
AutoCAD Forum
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Autocad automatically hides linked excel files

8 REPLIES 8
SOLVED
Back to AutoCAD Category
Back to Topic Listing
Reply
Message 1 of 9
nrussell4CW5T
Contributor
599 Views, 8 Replies
‎06-06-2024 01:19 PM

Autocad automatically hides linked excel files

nrussell4CW5T
Contributor
Contributor
‎06-06-2024 01:19 PM

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?

0 Likes
‎06-06-2024 01:19 PM

Autocad automatically hides linked excel files

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?

Report
Labels (2)
Labels:
0 Likes
Reply
8 REPLIES 8
Message 2 of 9
pendean
Community Legend
in reply to: nrussell4CW5T
‎06-06-2024 01:55 PM

pendean
Community Legend
Community Legend
‎06-06-2024 01:55 PM

What are you calling / mean by "hidden" please? Just so are all clear on the issue.

 

OR... explore the highlighted response here

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-file-is-hidden-after-accidentally-click.... 

0 Likes
‎06-06-2024 01:55 PM

What are you calling / mean by "hidden" please? Just so are all clear on the issue.

 

OR... explore the highlighted response here

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-file-is-hidden-after-accidentally-click.... 

Report
0 Likes
Reply
Message 3 of 9
nrussell4CW5T
Contributor
in reply to: nrussell4CW5T
‎06-07-2024 04:31 AM

nrussell4CW5T
Contributor
Contributor
‎06-07-2024 04:31 AM

nrussell4CW5T_1-1717759880402.png

 

The workbook opens hidden

0 Likes
‎06-07-2024 04:31 AM

nrussell4CW5T_1-1717759880402.png

 

The workbook opens hidden

Report
0 Likes
Reply
Message 4 of 9
pendean
Community Legend
in reply to: nrussell4CW5T
‎06-07-2024 05:26 AM

pendean
Community Legend
Community Legend
In response to nrussell4CW5T
‎06-07-2024 05:26 AM

If this tip does not help @nrussell4CW5T 

pendean_0-1717763106446.png

 

Then the Excel worksheet was linked to AutoCAD while hidden, you will likely need to unlink it then re-link when it is fully set and tested to be set to "unhide".

0 Likes
‎06-07-2024 05:26 AM

If this tip does not help @nrussell4CW5T 

pendean_0-1717763106446.png

 

Then the Excel worksheet was linked to AutoCAD while hidden, you will likely need to unlink it then re-link when it is fully set and tested to be set to "unhide".

Report
0 Likes
Reply
Message 5 of 9
nrussell4CW5T
Contributor
in reply to: nrussell4CW5T
‎06-07-2024 05:41 AM

nrussell4CW5T
Contributor
Contributor
‎06-07-2024 05:41 AM

No, I don't link excel sheets while they are hidden or not open. Deleting and reinserting the link doesn't fix this problem either. 

0 Likes
‎06-07-2024 05:41 AM

No, I don't link excel sheets while they are hidden or not open. Deleting and reinserting the link doesn't fix this problem either. 

Report
0 Likes
Reply
Message 6 of 9
pendean
Community Legend
in reply to: nrussell4CW5T
‎06-07-2024 05:47 AM

pendean
Community Legend
Community Legend
In response to nrussell4CW5T
‎06-07-2024 05:47 AM

Are you able to share both files here?

Is it a "protected" worksheet?

0 Likes
‎06-07-2024 05:47 AM

Are you able to share both files here?

Is it a "protected" worksheet?

Report
0 Likes
Reply
Message 7 of 9
nrussell4CW5T
Contributor
in reply to: nrussell4CW5T
‎06-07-2024 05:58 AM

nrussell4CW5T
Contributor
Contributor
‎06-07-2024 05:58 AM

No, they dont allow .xlsm files to be shared here. 

0 Likes
‎06-07-2024 05:58 AM

No, they dont allow .xlsm files to be shared here. 

Report
0 Likes
Reply
Message 8 of 9
pendean
Community Legend
in reply to: nrussell4CW5T
‎06-07-2024 06:48 AM

pendean
Community Legend
Community Legend
In response to nrussell4CW5T
‎06-07-2024 06:48 AM
@nrussell4CW5T wrote:

No, they dont allow .xlsm files to be shared here. 

Here are ways to open a support case with Autodesk if you are on subscription to seek out Autodesk Support's help:
https://www.autodesk.com/support/account/manage/use/support#:~:text=com/plans.-,Contact%20support,-S... 

0 Likes
‎06-07-2024 06:48 AM

@nrussell4CW5T wrote:

No, they dont allow .xlsm files to be shared here. 

Here are ways to open a support case with Autodesk if you are on subscription to seek out Autodesk Support's help:
https://www.autodesk.com/support/account/manage/use/support#:~:text=com/plans.-,Contact%20support,-S... 

Report
0 Likes
Reply
Message 9 of 9
nrussell4CW5T
Contributor
in reply to: nrussell4CW5T
‎06-12-2024 04:39 AM

nrussell4CW5T
Contributor
Contributor
‎06-12-2024 04:39 AM
Accepted solution

The solution was bluebeam was messing it up, if you uncheck this setting it fixes it. 

 

nrussell4CW5T_1-1718192342100.png

 

‎06-12-2024 04:39 AM

The solution was bluebeam was messing it up, if you uncheck this setting it fixes it. 

 

nrussell4CW5T_1-1718192342100.png

 

Report
Reply
Reply

Forums Links

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

AutoCAD Inside the Factory


Autodesk Design & Make Report

Report a website issue