I am using Excel 2016 and have two sheets "Base" and "Update" data. I have the data in tables for dashboard purposes.
However, i have several VBA compares that I run on the data and I noticed the other day that when the data is in a table the compares take about a 1 to 2 min's to run, BUT, if my data is not in a table the compare takes 10 to 15 sec's. When running 15+ report it added up.
Has anyone seen this? If so how did you address?
Thanks in advance for any and all help...
However, i have several VBA compares that I run on the data and I noticed the other day that when the data is in a table the compares take about a 1 to 2 min's to run, BUT, if my data is not in a table the compare takes 10 to 15 sec's. When running 15+ report it added up.
Has anyone seen this? If so how did you address?
Thanks in advance for any and all help...