Max number of worksheets in a file Bob W. 06.07.2006 15:57:02 Is there a limit on the number of worksheets that can be contained in a single Excel file?

Re: Max number of worksheets in a file Bearacade <Bearacade.2aj7iz_1152202504.0796[ at ]excelforum-nospam.com> 06.07.2006 16:10:56 I don't think there is a limit. But why would you want that many worksheets? It becomes unmanagable after X amount -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35016 View this thread: http://www.excelforum.com/showthread.php?threadid=558970

Re: Max number of worksheets in a file Bob W. 06.07.2006 16:26:02 My wife is a bookkeeper in a small law firm and uses Excel for keeping track of trust fund activity... she has a separate tab for each of the firm's clients and she's worried that too many worksheets will cause problems in Excel... currently she has about 350 worksheets in the file. "Bearacade" wrote: [Quoted Text] > > I don't think there is a limit. But why would you want that many > worksheets? It becomes unmanagable after X amount > > > -- > Bearacade > > > ------------------------------------------------------------------------ > Bearacade's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35016 > View this thread: http://www.excelforum.com/showthread.php?threadid=558970 > >

Re: Max number of worksheets in a file Gord Dibben <gorddibbATshawDOTca> 06.07.2006 17:02:22 Bob Help> "limits and specifications" says this............. Sheets in a workbook Limited by available memory (default is 3 sheets) 350 sheets is pushing the envelope vis a vis manageable. Not the number of sheets per se, but the attendant file size can get unwieldy. See Charles Williams' site for assistance and info on calculations and speeding up. http://www.decisionmodels.com/ Gord Dibben MS Excel MVP On Thu, 6 Jul 2006 09:26:02 -0700, Bob W. <BobW[ at ]discussions.microsoft.com> wrote: [Quoted Text] >My wife is a bookkeeper in a small law firm and uses Excel for keeping track >of trust fund activity... she has a separate tab for each of the firm's >clients and she's worried that too many worksheets will cause problems in >Excel... currently she has about 350 worksheets in the file. > >"Bearacade" wrote: > >> >> I don't think there is a limit. But why would you want that many >> worksheets? It becomes unmanagable after X amount >> >> >> -- >> Bearacade >> >> >> ------------------------------------------------------------------------ >> Bearacade's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35016 >> View this thread: http://www.excelforum.com/showthread.php?threadid=558970 >> >>

Re: Max number of worksheets in a file Bearacade <Bearacade.2ajbp1_1152207904.1846[ at ]excelforum-nospam.com> 06.07.2006 17:43:00 In your wife's case, I would definitely seperate out each client to their own workbook. For three reasons: Speed of calculation Size of File If something goes wrong with that one giant file, your wife is SOL. vs lost data on 1 client is MUCH better. -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35016 View this thread: http://www.excelforum.com/showthread.php?threadid=558970

Re: Max number of worksheets in a file Dave Peterson <petersod[ at ]verizonXSPAM.net> 06.07.2006 19:01:49 On the other hand, I would take a different approach. I'd put all the data in one worksheet in a single workbook. I'd add an indicator column (or a few) to show to whom the data belongs. But then I can use that giant worksheet to do other stuff--group results, charts and graphs, pivottables. If I needed to separate the data into separate worksheets to share, I'd put them in separate workbooks, too. Don't hide sheets or hide data expecting that others won't be able to find it in excel. (Excel's security isn't made for that.) This assumes that all the data fits in about 40k rows (sometimes excel will slow down greatly when the amount of data/formulas get too large). Bob W. wrote: [Quoted Text] > > My wife is a bookkeeper in a small law firm and uses Excel for keeping track > of trust fund activity... she has a separate tab for each of the firm's > clients and she's worried that too many worksheets will cause problems in > Excel... currently she has about 350 worksheets in the file. > > "Bearacade" wrote: > > > > > I don't think there is a limit. But why would you want that many > > worksheets? It becomes unmanagable after X amount > > > > > > -- > > Bearacade > > > > > > ------------------------------------------------------------------------ > > Bearacade's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35016 > > View this thread: http://www.excelforum.com/showthread.php?threadid=558970 > > > > -- Dave Peterson

Re: Max number of worksheets in a file SteveW <sj_walton[ at ]nothotmail.com> 07.07.2006 16:20:15 On Thu, 06 Jul 2006 20:01:49 +0100, Dave Peterson = <petersod[ at ]verizonXSPAM.net> wrote: [Quoted Text] > On the other hand, I would take a different approach. > > I'd put all the data in one worksheet in a single workbook. I'd add a= n > indicator column (or a few) to show to whom the data belongs. > > But then I can use that giant worksheet to do other stuff--group = > results, charts > and graphs, pivottables. > > If I needed to separate the data into separate worksheets to share, I'= d = > put them > in separate workbooks, too. Don't hide sheets or hide data expecting = = > that > others won't be able to find it in excel. (Excel's security isn't mad= e = > for > that.) > > This assumes that all the data fits in about 40k rows (sometimes excel= = > will slow > down greatly when the amount of data/formulas get too large). > > a *much* safer solution. But as with most *small excel solutions* that grow, difficult to think = like that at the initial design stage. Worth the effort in chanmging that though. -- = Steve (3)