Forum Discussion
Solved
Error Message Help
I'm receiving this error and have tried everything... I need a spreadsheet with unlimited columns.
Is their anyone out their who can give me the trick?
- If you're running an Enterprise version of Office then you have access to the Inquire COM Add-in. Inquire has a feature called Clean Excess Cell Formatting that will clear this up.
Reference on Clean Excess Cell Formatting: https://support.microsoft.com/en-us/office/clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738#:~:text=%20To%20remove%20the%20excess%20formatting%20in%20the,formatting%20has%20been%20cleared%2C%20click%20Yes...%20More%20?msclkid=5047c856b6b611ec88b142047ee0d3ee
Otherwise, you'd have to select the rows and columns beyond your data and delete.
4 Replies
Total number of rows and columns on a worksheet
1,048,576 rows by 16,384 columns
Excel specifications and limits
Thank you so much for responding! So my workbook has WAY less that 16,000 columns.... but it still keeps giving me the error and won't allow me to add more 😞 I just can't figure out how to correct that. I currently have less than 50 columns. Any ideas?
- If you're running an Enterprise version of Office then you have access to the Inquire COM Add-in. Inquire has a feature called Clean Excess Cell Formatting that will clear this up.
Reference on Clean Excess Cell Formatting: https://support.microsoft.com/en-us/office/clean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738#:~:text=%20To%20remove%20the%20excess%20formatting%20in%20the,formatting%20has%20been%20cleared%2C%20click%20Yes...%20More%20?msclkid=5047c856b6b611ec88b142047ee0d3ee
Otherwise, you'd have to select the rows and columns beyond your data and delete.
