I’m experiencing some problems when inserting an excel spreadsheet into Layout.
Firstly, the “Excel Reference Options” Sheet drop-down will only show one or two of the sheets. The only work around is to move the sheet i want to the first sheet position within the excel file.
Secondly, Most of the formatting and even some of the data is lost after insert. Notably the merged cells are no longer merged and all cells have borders even though they were clear on the original document. One larger sheet (design summary) loses all data from half way down the page and formatting is lost. The other sheet (PVSyst Summary) has all the data but the cell borders are all shown and merged cells are unmerged. see attached…
170313 Excel Import.pdf (285.1 KB)