Hey all,
I've got another quick, hopefully easy question. I've got a worksheet that loads data from another source for the employees to work with. Often we'll get several thousand records in one data pull, but other times there are only 100-200. If they've loaded a large amount of data, the righthand scrollbar will adjust size to hold that data, but when you clear it out and load subsequent data sets that are much smaller, the scrollbar stays the same size, making it hard for my users to scroll through the smaller amounts of data.
How can I force Excel to recalculate the size of the scrollbars at any given time?
Thanks in advance.
I've got another quick, hopefully easy question. I've got a worksheet that loads data from another source for the employees to work with. Often we'll get several thousand records in one data pull, but other times there are only 100-200. If they've loaded a large amount of data, the righthand scrollbar will adjust size to hold that data, but when you clear it out and load subsequent data sets that are much smaller, the scrollbar stays the same size, making it hard for my users to scroll through the smaller amounts of data.
How can I force Excel to recalculate the size of the scrollbars at any given time?
Thanks in advance.