OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Get all OfficeHelp.Biz CALENDARS at once!

Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
PC Tip Microsoft Excel OfficeHelp Free

Save Time, Save Microsoft® Excel Working Context - Not Just Files - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97


 


Microsoft(r) Excel is one of the most widely used software's in the world. It is true that most of its users only use it for small calculations and to draw tables, but many use it intensively for advanced calculations and complex projects. These advanced users usually open more than one file at the same time, many times interlinked. If that's your case, start saving time by saving projects and context instead of just files.

Saving Context instead of Files 

The common way of saving your Excel work when you need to leave is to save each file on its own. Excel will help you with that by asking to save each changed file if you exit it, before quitting. But all your work context is lost.

Next time you will need to work on that set of files, you will need to open them one by one. If they are from different projects, they may be saved on different places on the hard drive, making it hard work to restart.

There is, however, a solution: save your entire Workspace: files & context. This includes how windows are open inside Excel, the active cell and so on, as well as a link to each open file.

How to do it 

1) On the File menu, select "Save Workspace"

2) Insert the desired filename. It will have the extension ".xlw" for Excel Workspace

3) A small shortcut file will be saved on the selected folder. Each open Excel file is also saved on their original locations

4) Next time you want to use this set of files, just click the new shortcut: All files will be opened exactly as they where when you last saved them!

What if you forget and only save the files after opening a Workspace? 

Remember, the shortcut doesn't have your files, only a link to them and a copy of your working context. If you save the files, all your data will be updated on them, but the context won't. So, unless your context changed, you won't miss anything. If your context changed, only it will be lost, all important Excel data will, be saved in each file.

I need to carry my files to another computer. All I need to do is to copy the Workspace file, right?

No, wrong. It is just a shortcut. You will need to copy all files of your working set. Also, the shortcut won't work if your individual files are not exactly in the same disk folder as on the original computer, because the shortcut will expect to find them there. 

This is a time saving option for use on each PC only. Don't use it to carry context between computers unless you copy all files and place them exactly on the same disc place on the other computer.

Can I know more about this subject ?

Check our FREE PC Tips and Tutorials. They will be regularly published and will include some on Microsoft (R) Excel very soon. Better still, subscribe our Email Newsletter. You will be informed when contents updates are made and automatically granted participation on any future promotion.

Get FREE PC TIPS every month:

 

Save Time, Save Microsoft® Excel Working Context - Not Just Files - Version 1.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97


Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz