(No actual question)
Trying to load sheets made with V>=7.4.0 the warning “The data could not be loaded completely because the maximum number of columns per sheet was exceeded.” pops up even if all the additional columns are empty/unused, but a ConditionalFormat is defined for a range reaching to columns >1024 (AMJ).
In addition the respective CF is not correctly interpreted for the actually loaded range. This was observed with a CF of type ‘Formula is’ not referencing the missing range at all.
See How can I change the border on every nth row? for an example.
2 Likes