LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 54
Default To Database, or not...

To database or not to database, that is the question...

I'm running Excel 2003 under XP. I have several Excel workbooks that
I've built up over time. They basically store sheets of data and have
various programs I've written in VB or DLL files that analyze and/or
plot data. Sometimes one Excel program opens several of these other
workbooks to access their data too. I'm the only user of this system.

All is well and they work as desired. The thing is that some are
getting rather large. The biggest one is nearly 100MB (and yes, I've
crunched the bloat out of it which Excel can create). It's basically
one sheet for each date, and each sheet is maybe 25 columns by 1800
rows. There are about 200 sheets at present and adding another each
week for just this one workbook. My only complaint is that it can
take time to open or save the large files. Otherwise they seem to
work ok.

My question is whether I'm tempting fate with such large Excel files.
Will Excel become cranky and unreliable at some point, or will it just
get slower as the files get bigger?

I don't feel it's worth recasting everything into a database
repository just for speed (which I could also improve with better
hardware), but I worry a bit about Excel reliability.

Thanks.

Bill
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Excel Database via Access Main Database with a script Finnbar New Users to Excel 2 November 3rd 08 07:24 PM
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database Clinton M James[_2_] Excel Programming 1 October 8th 07 12:44 AM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
How to make reference to database and if true copy from database? V!p3r Excel Discussion (Misc queries) 4 February 5th 07 02:19 PM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Excel Programming 5 June 11th 06 09:43 PM


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"