- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
table command in 2020
I have an excel spreadsheet that is 137 kb. it is divided into 4 sheets. I am trying to insert the sheets using the table command. When I click on 'ok', nothing happens, I have waited 10 minutes to see if it inserts, nothing happens. Is it possible that the spreadsheet is too large? I have experimented with the various options in the lower right of the dialog box, nothing.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Hi
Try linking each sheet does it even load in the dialog box?
any error message?
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
There are 3rd party tools you can purchase if you want to do it the easy way, here is one of many (I am not affiliated with them at all) https://www.dotsoft.com/xl2cad.htm
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Do you only want to insert the contents of the Excel sheet? In that case you can Copy (CTRL+C) from Excel and use Paste Special to insert the contents as a table.
You might even want to use data extraction to link the table and the Excel sheet to keep updated data.
Kind regards,
Edwin Rense
Cadac Group AEC BV
Supporting Consultant AEC
Cadac Group .
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
I ended up copying and pasting the spreadsheet into paperspace, dividing the spreadsheet into 4 sheets of 50 rows each. This appears correct, as long as no updates are made to the spreadsheet, then I will have to re-paste the spreadsheet, but I honestly think it will not change now.