topic Re: Excel Links - Locked for Editing in AutoCAD Forum

Excel Links - Locked for Editing

Anonymous — Thu, 28 Sep 2017 18:49:47 GMT

We use the 'Paste Special' command to link Excel spreadsheets into AutoCAD for our schedules. When someone else in the office tries to open drawings for review (either in AutoCAD 2015 or TrueView), they get a notification that "(filename).xls is locked for editing", and they have to accept Read Only to continue. If there are 50 schedules, this can go on for minutes just to get the .dwg file open. If we're looking in TrueView (or read-only AC) and can't modify the spreadsheets in any case, why do we go through all this? Should we be linking the spreadsheets in a different way?

Thanks!

Tim

Re: Excel Links - Locked for Editing

john.vellek — Thu, 28 Sep 2017 21:31:11 GMT

HI @Anonymous,

Have you considered using Datalinks to see if that improves the workflow?

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Excel Links - Locked for Editing

john.vellek — Fri, 29 Sep 2017 18:59:51 GMT

Hi @Anonymous,

Did you try datalinks to see if that gives you better behavior?

I am checking back to see if my post helped you with your problem or question. Please mark a post or posts as accepted solutions if they resolved the issue or give me a bit more detail on this issue so we can continue to work towards getting this solved.

Please hit the Accept as Solution button if a post or posts solves your issue or answers your question.

Re: Excel Links - Locked for Editing

Anonymous — Fri, 29 Sep 2017 19:17:05 GMT

I looked into Datalink really quick, it looks like it would take a lot of formatting. I'll get into it more during a slow period.

Thanks!

Tim

Re: Excel Links - Locked for Editing

john.vellek — Fri, 29 Sep 2017 19:24:08 GMT

Hi @Anonymous,

Please let me know if you need help or additional resources when you have time to work on this.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: Excel Links - Locked for Editing

Anonymous — Wed, 18 Oct 2017 04:05:56 GMT

I have the same problem.

After windows update .

Re: Excel Links - Locked for Editing

john.vellek — Wed, 18 Oct 2017 13:38:44 GMT

Hi @Anonymous,

There is a known problem currently with three Microsoft updates causing lost functionality with AutoCAD and Excel. Here is my post regarding this issue.