Can it be made possible to add a table from an xlsm formatted excel spreadsheet to Layout
The excel file I use to bid jobs has a few macros to speed up data entry of the different materials and labor items. The final calculations end up on a summary sheet in the same excel file. I would like to link this summary sheet in a table in Layout. Unfortunately Layout will not allow xlsm formatted excel files. The summary sheet does not contain any macros, it is just the final data output.
Can layout be allowed to still pull in the info from a sheet from xlsm files and told to ignore macros?
It is my understanding that the tables feature is basically a window looking at the specified cells, and that it does not do any calculations. So it seems feasible to allow an excel file formatted as XLSM to still be seen through the window regardless of what the macros are doing behind the scene.
If there is a hack that doesn’t involve exporting to different file formats please let me know, but this would be awesome if it was just a standard option.