I have a floor plan of a building which includes all of the offices and cubicles. I have been given the task of finding a way to utilize Excel with AutoCAD so that an administrative assistant can change the drawing by making changes in the Excel spreadsheet. I've created a sheet with the room number, name, title and department in a row. I then went in and selected the 4 cells and did "define name" and named them by location number. I then went into AutoCAD and inserted a table and chose the cell that I had just defined. If I make changes in the spreadsheet, I receive a message to update the links. Any typed changes I make will update. However, if I add a color fill (which they are wanting to add by department) and I save the spreadsheet, the fill doesn't change in the CAD drawing. They are wanting this capability so that someone can just have access to the spreadsheet to make the changes and the drawing will always be up to date. Can anyone help me? I tried copying the cells in as "paste special" and bringing each room in that way. But if a row or column is added to the spreadsheet, it shifts the data accordingly. The cells don't remain "locked" to the coordinates of the cells.
