I've got an application that shows Revenue and Volume by client. At the top of the main tab, there are two big numbers that show the total Revenue and the total Volume for the entire company (based on the current selections). Underneath each number is an arrow. They point up if the number has increased since last year, and down if the number has decreased. So far, so good.
The arrow under Reveune behaves perfectly. However, the one under Volume doubles in size whenever we reload the data. Its height changes from 18 to 32, though the width stays the same. No other image does this and I can't duplicate it in a sample file.
Anyone seen something like this before? Any suggestions?
We think we've figured this out. It seems to happen if we reduce the data and save the file before reloading it. We were doing this because it has so much data it takes about ten minutes to save, so reducing the data first made it a lot quicker.
However, we also found that reducing the data, saving the file, closing it and then refreshing the data on the server (because it's more powerful and faster) meant that the arrow and list boxes and other objects had no data to interpret and therefore got confused. It definitely affected the sorting of charts since there was nothing to sort and whether the "Always One Selected Value" option was on because you can't select on value when there aren't any.
Why that also affected the size of this one arrow and none of the others is beyond me, but it hasn't happened since we stopped reducing the data before reloading.
We think we've figured this out. It seems to happen if we reduce the data and save the file before reloading it. We were doing this because it has so much data it takes about ten minutes to save, so reducing the data first made it a lot quicker.
However, we also found that reducing the data, saving the file, closing it and then refreshing the data on the server (because it's more powerful and faster) meant that the arrow and list boxes and other objects had no data to interpret and therefore got confused. It definitely affected the sorting of charts since there was nothing to sort and whether the "Always One Selected Value" option was on because you can't select on value when there aren't any.
Why that also affected the size of this one arrow and none of the others is beyond me, but it hasn't happened since we stopped reducing the data before reloading.
