Linked cells in excel not updating
First, you need to see whether you have any real external links (nonphantom) that you forgot about.If you are not sure whether you have real external links, start looking in the most obvious place: your formulas.The Excel file will not insert into the Auto CAD drawing or an established data link will not update reliably. I added some links to other Excel documents on a network drive.
To do this, we like to start from within the Excel workbook containing the phantom links.When I open the Excel files on the Sharepoint directory, they update just fine.When other users open those files, they don't update the links.This process is for linking summary boxes, traffic signs, camber tables, bottom of slab elevations, etc... Since the automatic update process isn't reliable, putting all of your Excel links into one dgn, then using Micro Station to reference them into your other dgns, would allow you to be able to update links in one place.Consider that anyone who works on the project might print or need access to the Excel file, it should be located near to the linked dgn.