Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

Got about 50 workbooks that cannot be merged but need to make the data available in a nice easy way. Aany ideas how to open and close multiple workbook modally i.e control remains in some interface / menu window? all workbooks have multiple sheets and need to be opened read-only. thanks

share|improve this question
Do they all have the same structure? Are you trying to summarize / find data within them? – DaveParillo Dec 3 '09 at 0:22
What do you mean they can't be merged? Why not run a script to merge them into a separate read-write workbook? Why would you want to open 50 workbooks all at once - that doesn't seem nice and easy. Give us more info. If it were me I would merge 50 workbooks into one workbook, one worksheet per workbook. – mindless.panda Mar 16 '10 at 14:57

2 Answers

up vote 1 down vote

It sounds like you just need to access the data from all your workbooks in one sheet.

You can use the following syntax to access the value of a cell in an arbitrary workbook/sheet.

=[workbookname.xlsx]sheetname!$D$10

Here's a link for more information.

share|improve this answer
+1 That definitely does sound like a more logical approach than opening 50 workbooks. – nhinkle♦ Sep 3 '10 at 3:46
up vote 0 down vote

Maybe the simplest to use is a good program launcher.

The article Best Free Program Launcher lists many free launchers (see also the comments).

After a quick look at some screenshots, maybe your best bet is 8start Launcher, but as I said this was after taking a (too?) quick look.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.