fbpx
Search
Close this search box.

Work with several Excel files everyday? – Save them as a workspace [Quick tip]

Share

Facebook
Twitter
LinkedIn

If you work with multiple Excel workbooks everyday, then here is a handy tip.

Excel workspace feature - what is it and how to use it?

 

  1. Save Workspace button - Excel ribbonOpen all the files you frequently use together.
  2. Go to View ribbon and click on Save Workspace
  3. Give a name to your workspace
  4. Now, whenever you need to open all these files together, just double click on workspace file in your explorer.
  5. You are done!

Workspace saves not just file collection, but also window layouts. That means, if you like to arrange your Excel windows in a specific fashion, you can save this arrangement too.

Bonus tip: Use specific filter criteria all the time? Try custom views.

More tips on using Excel & shortcuts.

Do you use workspace feature?

I find workspace feature to be very useful when I need to work with multiple files, especially in cases like file comparison and consolidation. I can save the file layout as a workspace and re-open it whenever I want to resume the work.

What about you? How do you use workspace feature? Please share your tips & experiences with us using comments.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

28 Responses to “Work with several Excel files everyday? – Save them as a workspace [Quick tip]”

  1. Rahim Zulfiqar Ali says:

    Thanks for this great Tip. 🙂
    My Question: What if, the excel files location change on drive ? Still workspace support ? Or all the files needs to be saved on similar location and we cant moved their location in Future ?

  2. That option is not availlable in Excel 2013 🙁 I really miss it.

    • LPA says:

      I AGREE!! I CAN'T BELIEVE THEY TOOK THIS FUNCTIONALITY AWAY FROM US. I USE CERTAIN WORKSHEETS TOGETHER FOR DIFFERENT PROJECTS AND THE "SAVE WORKSPACE" OPTION SAVED ME TONS OF TIME!
      HOW COULD IT BE GONE! (I CAN OPEN OLD WORKSPACE FILES (.xlw), BUT NOT CREATE NEW ONES.) THIS IS SUCH A PROBLEM. NOW I CAN'T UPGRADE MY OLDER EXCEL SOFTWARE!
      PLEASE, PLEASE, PLEASE BRING BACK "SAVE WORKSPACE" TO EXCEL 2016 AND FUTURE VERSIONS!!!

  3. [...] Follow this link: Work with several Excel files everyday? – Save them as a … [...]

  4. Pradeep D says:

    This is an excellent option which I was not aware of till now. I've a challenge here. It is not preserving the zoom. i.e., I've save the workbooks with different zoom levels (75% for one, 85% for the second and 90% for the third) to show at the time of opening. When I use this option, it is opening with 100% zoom.  Is there anyway to preserve everything including the zoom?
     
    Thanks and regards,
    Pradeep D
     

  5. Robert Crocker says:

    I have not used the Work Space feature, but I'll be looking for opportunities now. Thanks for the great tip!

  6. Vinod says:

    Never heard of this item

  7. Bakkiyaraj says:

    Hi,
    Work with several Excel files everyday, These is very use full creation. It's very useful one. Thanks lot.

  8. VEERU says:

    Thanks for this great tip.
     

  9. Abdulrahim says:

    I m using 4 excel workbook at  the same  time for judgement of order placement.
    1. for getting data from 3 sheets ( vlookup)
    a. for 3 month stock
    b. for monthly sales and purchase
    c. back order from supplier
     

    • Tisme says:

      I urgently need help. I've been working on excel for a while which got me deceived into believing that i'm very proficient in use of excel. well, i decided to push the limits and designed a prototype software for business analysis using excel and presented it to a prospect. They liked it and requested for a full scale software to manage their entire business processes from prospecting to printing and sending reports
      The software is supposed to be shared by multiple users (say  staff) and will be hosted later on a website; this, for me is quite advanced and i'm quite skeptical of excel's ability accomplish these. I need some some help and advice on whether excel can function as a full scale database and its limitations. Pls respond ASAP. Thanks

  10. Nandy says:

    This is simply awesome!
    I have been working on excel for like years and have broken heads and this is like a one click solution.
    I am kicking myself for not even looking at the ribbon seriously!

  11. Tisme says:

    i'm not also not so sure if this is risky regarding the volume of task to be entered into this software

  12. Jasmine says:

    I just knew this wasn't going to be available in Excel 2003. I'm the only one in the office who still has 03, everyone else has 07...and I'm the only engineer in the office who could use some 07 features in work life. Oh the irony.

    But it is File>Save as workspace. I NEVER noticed it before. Thanks for the tip ^_^ 

    • CSR says:

      Thanks Jasmine (and Chandoo)! I use 5 worksheets regularly every day and I'm the only one w/ '03 as well so I figured I was out of luck!

  13. vinayak says:

    Very good option for daily use of multiple excel sheets.
     
     

  14. louis szanto says:

    How do I get the 95 tips and tricks with excel?

  15. Elle says:

    Awesome!
    I'll try it later since I work with multiple Excel files EVERY DAY!!

  16. Connie says:

    While using two screens and working in workbook space view, I find that I cannot move any of the workbooks onto my other screen. I would like to move them from one screen to another! Also how can I undo workbook space?
     
    Thanks for your help!

  17. mZee says:

    Thanks for this awesome tip, i never used it before!
     

  18. outlr says:

    Good Work,Keep Posting

  19. JoshA says:

    You can’t save the current layout of all windows as a workspace. The Save Workspace command is no longer available in Excel so you won’t be able to add it to the Quick Access Toolbar. However, you can still open a workspace file (*.xlw) that was created in an earlier version of Excel.

  20. Bars Da says:

    This is a tip related to the above. My method for getting to the top 20 EXCEL files that I most often use:
    The default file folder for my EXCEL contains 20 shortcuts to the actual files. I prefix each shortcut name with a number so that they get sorted in the order that I most often use.  For example, it could look like this:
    100 Shortcut - Checkbook 2013
    101 Shortcut - Passwords
    102 Shortcut - Todo List
    etc.

  21. Jason Carmichael says:

    Great, I just "upgrade" if that's what you want to call it to 2013, I have finally decided that the 3 files I open everyday  has got to be an easier way. So search google and low and behold Workspace. Thanks MS. But wait, heyy that's not cool Where the heck did you take workspace MS? Good job bone head. Just like telling everyone that MSNQuotes doesn't work either.

  22. Car53 says:

    Microsoft took this away with Office 2013. They're opting for more shallow-thinking users, I guess. This was a powerful feature I used a lot. We can only hope someone comes up with a product that satisfies the more complex spreadsheet user.

    • Hui... says:

      @Car53, Jason

      In 2013 "Save Workspace" is under the View tab, Save Workspace

      • Excel 2013 sucks says:

        No its not

      • Merry says:

        If you look at MS Office's website, they distinctly state that for the 2013 version the Save Workspace button, option, function, feature has completely removed from the program. Stupidest thing they could have done IMHO. Only the versions prior to the MS Office 2013 have it.

Leave a Reply