I am using the excel charts to display my monthly production progress. I review the chart daily, as it is broken down by days of the month. The refresh time is minutes. Way to long. I dont need to look at past months data on a daily. How can I get the data to refresh only for the month desired. (present month).?
Really hard to say without any idea of what you currently have set up and why it's taking so long.
But look into using Named Ranges to display only a subset of the data.
Thank you. That seemed to help. I set it up for a 24 hr search rather than full data. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks