View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Feasibility of 365 day workbook???

Ah, I wasn't aware of that, looks like there are more relevant answers there
based on the additional details the OP gave in that thread, than the answer
I just gave.

Regards,
Peter T

"Barb Reinhardt" wrote in message
...
Unless this is a different question than the one you posted a few days
ago,
you've already gotten answers in the previous thread.

Barb Reinhardt



"Robert Crandal" wrote:

I'm thinking about creating a SINGLE accummulative
worksheet for the year 2010 to save our company transactions.

Each day, we will fill in 260 cells of data, which means that
after 365 days (1 year), our single sheet will contain
94,900 cells filled with data.

Does anybody see any problems with storing this much data
on a single sheet?? Is it a bad or inefficient idea??

In 2009, we stored our daily transactions in their own
separate Excel files, which means that I have 365 individual
files at the end of the year, which seems kinda inefficient.
Wouldn't having a SINGLE data worksheet be a better
(and cooler) idea??

Please let me know what u think.

Sincerely,
Bob


.