I am working with a factory design that features ~100 conveyors. Curently, conveyor width/length/inclination data is exported to a spreadsheet by exporting the BOM, where relevant information is pulled into a separate shared spreadsheet (via excel's Import Data feature) that acts as the live BOM for the project - information about motors, gearboxes, ratios, drum sizes, bearing assemblies, etc.
However, Excel does not like having the data source overwritten while the live spreadsheet is open. This is frustrating, as there are multiple people who have the spreadsheet open at once (and all would have to close it), and not as smart as I had hoped - you cannot update the source information live.
Is there a better way of doing this? Or is there a tool that allows for data from FDU to be pushed to a database that can be accessed by multiple people / pushed to a spreadsheet that can be accessed by multiple people?