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 l…

Did you try a test by copying the file to a new file and renaming with just a .xls extension and see if LayOut has any problem reading the file? If not then it’s just an extension filter on the Insert dialog, and the answer to you question would be “Yes it can.” That would lead to the next question…

Thanks Dan, I am able to rename the file to xlsx and bring in the data, but I am not sure if that is a valid test to see if the macro has any negative effect on layout since renaming the file automatically deletes the macros. I hope that a security concern would not stop them from implementing thi…

[image] Benham_Design: … but I am not sure if that is a valid test to see if the macro has any negative effect on layout since renaming the file automatically deletes the macros. Renaming manually in File Explorer deletes the macros ?

You should be able to use the macro embedded in a xlsm to work on any xls file by referencing using thisworkbook. I private messaged you with my email contact which you can respond too if you wish, as xlsm can not be shared on this forum

Thanks Philip for the suggestion, I have something similar set up pushing the data to a seperate worksheet that can be brought in, but this creates another level of file management. To keep each project’s data seperate a new separate file needs to be created for each project. This introduces more …

Can I add a table from an xlsm formatted Excel spreadsheet into Layout

LayOut Feature Requests

Topic		Replies	Views
Wish 4 next layout version: xlsm import Feature Requests excel	2	513	June 29, 2020
Can't Effectively Copy and Paste from Excel to Layout 2020 LayOut	57	5082	November 4, 2022
Layout 2026 not allowing .xls import? LayOut	6	110	January 14, 2026
Insert/import an excel macro document isn't working Feature Requests advice , excel , technical-problems	10	1437	February 18, 2020
Import .xlm file LayOut	8	1122	January 25, 2018

Can I add a table from an xlsm formatted Excel spreadsheet into Layout

Related topics