Excel Table - Text Disappears for Second User

[North9ON]

We have Map 2011 and I created a drawing with several tables pasted from Excel. Also, we are currently restricting our file format to AutoCAD 2010.

 

The tables pasted from Excel initially worked great and I was able to perform several edits and plots without any problems. That is, until another user opened the drawing.

 

At that point, the table lines were still present but the text was missing.

 

Also, I see the text when I open the drawing but I find that I can only edit the text using find/replace. Double-clicking does not open the text for editing.

 

Is there a fix for this besides exploding the tables?

 

Thanks.

 

Brian.

Edited February 13, 2012 by North9ON
Refined the explanation

[SLW210]

Is Defpoints layer off or frozen? What about Layer 0?

[North9ON]

Both layers are on and thawed.

[SLW210]

Have you tried creating a new file, by _WBLOCK the table?

 

Is it just this one drawing?

 

Can you post some images or the dwg file?

[North9ON]

I haven't tried anything yet besides editing the tables and saving the drawing again. This is just one drawing so far.

 

I don't see any option for uploading a dwg file.

[SLW210]

Select "Go Advanced" at lower right of Reply box, then "Manage Attachments".

[North9ON]

I get a 407 error from the forum upload interface when I try uploading a file - dwg or jpg I get the same error.

[eldon]

Are there not machine specific paths for the inserted tables? If someone else opens the drawing, these paths might be altered. Then you would have to re-establish the link path.

[North9ON]

I have checked the drawing over and I have not been able to see any links associated with the tables.

[jweigle]

You may want to check on the version of Excel you are using to the version of Excel your co-worker is using. Is your file saved as a .xls or .xlsx?

 

Only reason I say that is it may differ in results if you or your co-worker open the files in different formats or versions of Excel(2007, 2010, etc.).

 

I have AutoTable loaded on my computer and it works well, regardless of the version.

 

Here's the link if you want to find out more - Good luck.

 

http://www.cadig.com/products/index.php

[North9ON]

One thing I was wondering is if the upgrade to AutoCAD Map 2012 might solve the problem. I understand the support for Excel has improved from 2011 to 2012.

[North9ON]

We are all using Excel 2007 and AutoCAD Map 3D 2011.

[North9ON]

We have yet to figure out why a second user is unable to see the text in an Excel table.

 

Drawing attached.

B-1412 Export.dwg

[ReMark]

It does not sound like you verified that the path to the Excel files is the same for the second user as it is for you. You're both working off of a network server right?

[North9ON]

Where would I find the path that AutoCAD is using to locate the tables?

 

If you open the drawing, is the table text missing for you too?

[SLW210]

I show missing references on your H drive.

[North9ON]

Where would I see the missing reference to the H: drive? It doesn't seem to be in the properties for the table.

 

Thanks.

[ReMark]

No Excel files included with your drawing from what I can see here.

 

Does your co-worker have access to the same network drive and folder that you do? Yes or no? We're talking about the one where the Excel file(s) reside.

 

Did you scan the spreadsheet and insert as a PDF?

 

You do know that AutoCAD was given the ability back in the 2008 version to create a Datalink between AutoCAD and Excel right?

[North9ON]

Unfortunately, I don't think I can give you a yes or no answer.

 

When I originally did the drawing, I copied the table data from a temporary Excel file and pasted it into the drawing. I didn't intend to link the Excel file to the drawing because I was doing a one-time migration of the Excel data to an AutoCAD table to save manual copying. The other user probably doesn't have access to the original Excel file.

 

I have not kept track of the location of the Excel file because I did not intent to maintain a link to it.

 

Is AutoCAD somehow making reference to the Excel file anyway when I open the drawing? If so, where does AutoCAD maintain the link reference?

 

The drawing itself is on a SharePoint server. The other user can open the drawing from the server just like I can and see everything - except the text in the table. The file I attached to the forum post was created from the drawing on the SharePoint server using AutoCAD's File>Save As.

[eldon]

I think my reference to a pathing glitch was probably a red herring

 

I downloaded your file and opened it in Dwg TrueView. There were tables with text - nothing obviously missing. When I tried to list the table, I could not pick it, but could select it by windowing. Something is not quite right. Have you tried to run Audit?

 

Further, I converted it (in Dwg Trueview) to version 2004, which could see tables, but on trying to open the drawing, I got error messages and AutoCAD shut down. Something is not quite right. Have you tried to run Audit?