Workbook taking forever to load ...

[adambc]

... my WB has a table that has 30 columns and just over 1000 rows - it also has some (internal to the WB) IFs and XLOOKUPs (but nothing that complicated!) - but is taking a long time to open, every time ...

In a copy I have stripped out all the Worksheets other than the WS containing the main table, removed every formula, got rid of all data validation, removed conditional formatting, etc, etc - but it's still taking a long time to open, every time!

Can anyone help me get to the bottom of this?

I've tried Inquire but it just hangs Excel when trying to clean up ...

The table is correctly sized ie only to the last row/column in the table ...

And I'm out of ideas ...

Thanks ...

PS have just copied/pasted as values the table to a new WB - MUCH smaller file size and opens in seconds - so I also copied/pasted the table to a new WB and the same thing ... it's taking a long time to open, every time! - there's something in the table which I haven't found yet?!!!

 

[Logit]

Are you agreeable to remove any confidential data from your workbook ... then post it for download ? Provide a link here to the download location ?

 

[adambc]

Are you agreeable to remove any confidential data from your workbook ... then post it for download ? Provide a link here to the download location ?

@Logit

As much as I’d like to, the WB contains so much confidential information, it would take a long time to prepare it for outside consumption - I think I’m going to try to rebuild it from scratch and copy the data across as values for the columns that aren’t calculated - I have previously copied across the whole table as values into a new WB and the size of that file was minute compared to my WB!

Thanks again for persevering …