Excel Links - Locked for Editing

[Anonymous]

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

[john.vellek]

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.

[john.vellek]

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.

[Anonymous]

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

[john.vellek]

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.

[Anonymous]

I have the same problem.

After windows update .

[john.vellek]

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.