You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Chalfie
A silly question.
I have some data in one worksheet. I have defined the ranges of data using the named ranges in excel 2010.
This is great. It means I've defined things like "year" and "month". Because, I'm going to have to periodically dump data into this sheet.
I've then set up a calculation spread sheet off of this. So that I can calculate things like the number of times x happens in year 1, month 0, for a particular place. (i.e. countifs)
I have three sheets of data that will have data dumped into them. And each data sheet has a calculation sheet attached to it.
The problem is, my book has started to slow down a lot. Deleting and moving sheets around is not instantaneous. Is there a limit to how many ranges I can use? Am I, in essence, creating lots of pivot tables in one book?
What I want to do is dump data from each source into its respective sheet, have the calculation sheets calculate things. And then produce 1 summary table from each calculation sheet. With some graphs.
Because the ranges are dynamic, this should mean that i have to do very little but export data, import data, look at summary table and graphs. Shout when something looks wrong.
Does that even bro?