Excel in Excel

Can you create sub workbooks inside a workbook?


I tried googling but I'm unsure how to ask it to make my point. I'm perfectly ok with bootay calling me a dumbass.

 

not that I know of but I am sure Bootay will be here soon to tell me I am stupid

 

i have no idea but i'm sure bootay will be along to tell me how dumb y'all are

 

Ask these guys: http://www.mrexcel.com/board/index.php

 

You mean, other than worksheets? You get 3 worksheets by default in any new Excel file. They're tabbed at the bottom.

 

Thanks math!!!!!


Actually... I want to click on the tabby thingy at the bottom and have another whole workbook inside the tabby thingy. A subworkbook inside a workbook.

 

no

 

whatever

 

That's actually a really good suggestion for a future version of Excel. It'll be VERY confusing and hard to generate a UI that solves that, but that's for the product group.

Can you outline why you want to do that? Why not make that sub workbook an separate workbook or a series of tabs in a workgroup (maybe naming them appropriately to group them)? Is it just organizational (you want "history" tabs and "current" and "projections" all organized, or maybe by year), or something else?

FYI: you can save a WORKSPACE as a file, which basically allows you to open multiple excel files with windows arranged just so by opening the workspace. That might make all of your stuff easy to access without the worksheet tab linking to a sub-workbook (with it's own worksheet tabs) concept.

 

I work in an environment where it's crucial, by law, that our employees have access to certain information at their disposal. The information changes depending on the region and I update the manuals physically, as our committees decide what we need and don't, which is sometimes quite frequent. I cover a big reigon, and keeping the manuals updated for all the accounts is nearly impossible.

The information itself I keep updated and have changed almost everything over to Excel so I have multiple workbooks that include networking information for multiple locations, policies, protocols etc...
The information in each workbook is huge and very specific for each account.

My thinking is to somehow make an electronic handbook so I could update it via email/remote or put it on our employees work pc, so everytime a policy or something changes I don't have to drive to Charleston or farther because I don't trust anyone to update it physically, although they may have it electronically. They need to access it immediately for emergencies or inspections and flipping through mountains of emails won't work.

I got into this much detail because it doesn't have to be in Excel if I could use the excel workbooks inside it. Maybe there's another program that would
incorporate several programs into a booklet form and I'm just not that familiar with software.
Using an online database/server to store the info is not an option. It has to be on the desktop of their pcs for this to work so excel inside excel would be perfect.

Thanks bootay.