RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 788
- Office Version
- 2010
- Platform
- Windows
Hi all,
We have a master database of thousands of rows (3,200 so far), each row is a product with the necessary information. We are looking at implementing a new set of products, which will require a new row per product. It's likely we will be adding somewhere between 10,000 to 20,000 rows.
My question is, how do I stop this from getting unwieldly? Currently my plan is to remove all conditional formatting and replace it with a macro that applies a format (which is usually coloured cells or text) correctly based on the status of the product. I feel like 3,200 cells across 13 columns (41,600 cells) of conditional formatting already makes the sheet sluggish so this is the first step.
Obviously, it's not ideal to keep a database for this purpose in Excel, but these are the tools we have and I have to make the best of the situation. Any more advice given would be appreciated. Thank you!
We have a master database of thousands of rows (3,200 so far), each row is a product with the necessary information. We are looking at implementing a new set of products, which will require a new row per product. It's likely we will be adding somewhere between 10,000 to 20,000 rows.
- Each row has data up to column AF (32 cols).
- There are no live formulas
- There is conditional formatting on each row up to column M
- The sheet is already somewhat sluggish to use
My question is, how do I stop this from getting unwieldly? Currently my plan is to remove all conditional formatting and replace it with a macro that applies a format (which is usually coloured cells or text) correctly based on the status of the product. I feel like 3,200 cells across 13 columns (41,600 cells) of conditional formatting already makes the sheet sluggish so this is the first step.
Obviously, it's not ideal to keep a database for this purpose in Excel, but these are the tools we have and I have to make the best of the situation. Any more advice given would be appreciated. Thank you!