Yes we use 2021.

From experimenting, we can only get the pivot tables to work when we unformat the data in excel before we import it into layout. Is there are place where I can read what is specifically supported in Layout in regards to spreadsheets?

Hi,

I use Layout professionally in the office as an architect.

We are currnetly trying to figure out how to better reference our project excel schedules into Layout.

At the moment we have a typical fittings + fixtures excel scheudle which lists line by line each item, price, code, suplier etc. Seperate to this excel file, we like to produce an A3 page with all the fixtures data simplified and broken down into rooms + image or each item to show the client. To make this work visually on an A3, we need to reformat the data from a left to right data entry in excell to seperate top to bottom tables in layout.

We are currently experimenting with Pivot tables in excell to see if we swap to an top to bottom data set to directly reference it into layout to avoid doubling up on work.

Does anyone know if Pivot tables are reconised in Layout. Currently we cannot get Layout to reconise the pivot table cell, or are they not supported in Layout? I can provide files if nessesary.

Any help or insight would be much appreciated!

Thanks, Jack

Sorry for the late reply,

Yes I can upload the file, here's a google drive folder link. Apologies, the file has become a little bloated.

As some further background on what may have cause this, we were using a app called cross reference orginizer. This app essential functioned as an automated importer and updater for when you split your file up and import one file into the other. We have since abandoned it since version 2.0 broke the app and the devs made no attempt to fix the bugs. This is the website for the app, https://www.lasuapps.com/ .

LEN-DD 1 is an amalgamation of 3 seperate files, I have a feeling the cross reference orginizer might have had something to do with it but I'm not 100% convinced.

Hi,

I've had a trawl of the forums and this issue has been talked about before back in 2010, however maybe there is some new information?

I am currently having issues with Layout duplicating our styles as we update our model in layout, our styles start to multiple and we end up with for example: OOF SEC1, OOF SEC2, OOF SEC3 and so on (see the attached image https://imgur.com/a/SFaFZIP ).

Is there any way to avoid this? On multiple occasions we update our model references in layout and anywhere from one to all of scenes will change the style from our documentation style (DOC SEC) to our edit style (EDIT) or our sketchy style for flythroughs (OOF SK WHT SEC), we are really unsure why and how this is happening. Any insight would be very much appreciated!

The part of this issue that makes this issue unbearable is when one or all of the sketchup model windows shift position or change style / perspective. when this happens I need to go through every drawing and re apply the correct style and fix each model window.

We are running Windows 7 and 10, and using Sketchup 2018 and Layout 2018.