Sat 22 Apr 2017

Tips & Tricks 159 - Prompted to "Save File" even if I haven't changed anything

By |Saturday, April 22nd, 2017|Categories: Tips and Tricks|Tags: , , , , , , , , , |0 Comments

When you open a workbook and you change something in the workbook and you close the workbook, it will ask you to save the workbook. But sometimes, even if you have not changed anything, still the workbook asks to be saved even if you haven't changed.

Point 1 - Microsoft has provided the answer to this question at following link -

(more…)

Sat 10 Dec 2016

Tips & Tricks 151 - Saving in ODS (OpenDocument Spreadsheet) but Don't Need Excel Warning Message - "Do you want....."

By |Saturday, December 10th, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , , , |0 Comments

Question - Sometimes, I may require to work in different Office Suites and to maintain compatibility, I use Open Document Format. But whenever, I save in Open Document Format (ODS - OpenDocument Spreadsheet), I get the Excel warning like below. I don't need this. What is the way out?

1

Answer - This requires a registry hack, hence you need to take the backup of your registry first. Also, if you are not comfortable with modifying your registry, don't proceed.

For backing up your registry and restoring in case of any issue - https://support.microsoft.com/en-us/kb/322756

1. Press Windows +R, type regedit and press Enter.
2. Navigate to the following location:
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
(In case of Excel 2013, replace 16.0 with 15.0, Excel 2010 - 14.0, Excel 2007 - 12.0, Office 2003 - 11.0)
3. Right click on the in the left panel and select New>DWORD.
4. Once new DWORD is create right click on it and select Rename asDisableSaveAsLossWarningOpenDocumentSpreadsheet
5. Set Value data 1 to suppress the warning message.

Sat 26 Nov 2016

Tips & Tricks 150 - Save Each Worksheet as Different Workbooks

By |Saturday, November 26th, 2016|Categories: Tips and Tricks, VBA|Tags: , , , , , , , |0 Comments

You have got a workbook and you want to save each worksheet as different workbook - You can adopt following method to do so if worksheets are not many in number.

1. Right click on a worksheet tab
2. Move or Copy
3. Select new book
4. Save this new workbook
5. Do it for all 20 worksheets.

(more…)

Sat 23 Jan 2016

Tips & Tricks 127 - Change Default File Extension for Saving

By |Saturday, January 23rd, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , |0 Comments

We know that when we save an Excel file, it gets saved as .xlsx file.

1

But sometimes, few users may need to change the default file extension to something else. You can change it in

File > Options > Save

1