Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memory space
Hi
I need to provide caller / officer stats sheets for every working day of the year, quite a lot of figures for each day. What I was wondering was, which would be the best use of memory: 52 weekly worksheets, each with 5 days' worth of figures, or 312 pages each with just 1 day's worth? We use Excel 2007, if that makes any difference. Thanks for any advice Ttacey |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memory space
Hi Tracey
As each worksheet eats up a certain amount of space for the code required to tell Excel that it exists, and considering that there is going to be some redundant data in the form of column/row headings, I think that 52 weekly sheets will probably consume less memory space. "Tracey Stevenson" wrote: Hi I need to provide caller / officer stats sheets for every working day of the year, quite a lot of figures for each day. What I was wondering was, which would be the best use of memory: 52 weekly worksheets, each with 5 days' worth of figures, or 312 pages each with just 1 day's worth? We use Excel 2007, if that makes any difference. Thanks for any advice Ttacey . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memory space
Memory is not going to be an issue. The overhead of a sheet is very minimal.
The bigger concern will be the manageability of the spreadsheet. At 52 tabs it will be difficult to manage. At 312 it will be darn near impossible. -- HTH... Jim Thomlinson "Tracey Stevenson" wrote: Hi I need to provide caller / officer stats sheets for every working day of the year, quite a lot of figures for each day. What I was wondering was, which would be the best use of memory: 52 weekly worksheets, each with 5 days' worth of figures, or 312 pages each with just 1 day's worth? We use Excel 2007, if that makes any difference. Thanks for any advice Ttacey . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memory space
Hi,
Thank you for the reply. I'd decided it would be easier for me to stick to the 52 / 53 weeks' plan. Thank you! Tracey On 9 Feb, 14:41, Minty Fresh wrote: Hi Tracey As each worksheet eats up a certain amount of space for the code required to tell Excel that it exists, and considering that there is going to be some redundant data in the form of column/row headings, I think that 52 weekly sheets will probably consume less memory space. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Memory space
On 9 Feb, 15:24, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: Memory is not going to be an issue. The overhead of a sheet is very minimal. The bigger concern will be the manageability of the spreadsheet. At 52 tabs it will be difficult to manage. At 312 it will be darn near impossible. -- HTH... Jim Thomlinson Hi Thanks for your reply. My husband got round this by doing a 52 / 53 week plan, and nameing each tab "w/c xxxx" where 'xxxx' is the date of the Monday of each week. He then put a pop-up calendar control on another sheet to select the appropriate week. He knows nothing about how Excel works its' memory, though, so couldn't help me. The 52 week idea is much more manageble, yes. Thanks again! Tracey "Tracey Stevenson" wrote: Hi I need to provide caller / officer stats sheets for every working day of the year, quite a lot of figures for each day. What I was wondering was, which would be the best use of memory: 52 weekly worksheets, each with 5 days' worth of figures, or 312 pages each with just 1 day's worth? We use Excel 2007, if that makes any difference. Thanks for any advice Ttacey . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
Can I automatically add space after ea. row ("Space After" in Word | Excel Discussion (Misc queries) | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) |