Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts
Monday, September 29, 2014
How to Solve “This file is not in a recognizable format” Error of MS excel
Image via Wikipedia -->
MS excel is one of the most importantspreadsheet application for computer users. Storing and managing data is very easy with Ms excel. All important data saved inside these excel sheet. Imaging the situation in which you are trying to open an important excel sheet but could not do so, it gives some error. These errors means that your spreadsheet is get corrupt and you need to repair it to repair your valuable data. Excel recovery is required to repair this damaged .xls sheet.
Microsoft offer solution for corrupt excel sheet where you have to link the corrupt spreadsheet with news one. But this solution work hardly ever. So here I am going to explain a solution to easy repair of damaged excel sheet.
Follow the steps given below to:
- Open an undamaged workbook and a new workbook.
- In the Insert menu of new workbook find hyperlink and create link with undamaged workbook. Now close undamaged workbook.
- The link in cell A1 displays the path to the non-corrupted file. Edit the formula in cell A1 by substituting the corrupted file name for the existing one.
- If it works, the corrupted file will open. In this case, copy the formula down and across until the link returns blank cells.
- Select the data, copy it, and choose Paste Special from the Edit menu. In the resulting Paste Special dialog box, click Values and click OK to paste the data over itself. Doing so removes the link formula, but the values returned by the link remain.
Sunday, September 28, 2014
Top Excel 2013 Free Featured Apps
An App is the combination of an XML manifest file and a webpage as you can clearly check in below picture:
App for Office= App Manifest + Webpage
Excel Apps is one of the best & most exciting feature of version 2013. These Apps allow you to add more additional functionality to your documents that provides more unified web-based extensibility platform for Excel. Microsoft added many different free & featured apps for Excel 2013 which you can easily download from Microsoft Store. You can use these apps in all Office 2013 and Office 365 versions like Home Premium and Small Business Premium. There are two types of apps available for Excel: Content apps and Task pane apps.
Content Apps: Content apps allow you to extend apps with custom content. These apps are embedded inside your worksheet and saved with it.
Task Pane Apps: We can use Task Pane Apps side-by-side with an Office document. While you are working in these apps, it opens a task pane on the right side of Excel Sheet.
An independent companies can also sell their apps if it works within Office. A company can easily post their Apps in the MS Office Store. If you also want to make your own app then You can make it easily by using following steps:
How to build Apps:
It covers three steps: Design, Develop, Publish
DESIGN: In this section, Microsoft guides you about design decisions that you will make and offer best practices to build your app.
DEVELOP: In this section, Microsoft provides in-depth overviews, how-to articles, and code snippets to help you in develop your app.
PUBLISH: If you built your app then you can easily publish apps in the Office Store.
How to Start an App:
You can start these apps in Microsoft Excel 2013 by using following steps:
First open Excel 2013:
Now Open Blank Workbook then click “Insert” ribbon.
Now on dropdown box “Apps for Office”. Click on dropdown arrow and click on the “See All”.
After click on “See All”, you will find all the list of Free & Featured apps.
Click on “OFFICE STORE” link after that you will see this window “Please sign in with a valid profile to see apps”
sign in with “Live ID”.
After log in, go to “Apps for Office” and click on “Office Store” link.
After that you will see apps. Click on required apps and then click on “Insert” button.
Apps will be successfully added into your Excel Sheet.
How to disable these apps:
If you want to disable an app for Excel then you can easily do it by hiding it. After that you will see that it is not showing in your apps list. Here are all steps:
First Click on Insert button & then App for Office
Click on Manage Apps
Find the app in the list that you want to disable & then click Hide
Now you can check your hidden apps: Click >>Show>>Hidden.
Some of the famous Apps:
Bubbles:
The Bubbles add-on for Excel 2013 shows worksheet data in form of bubbles of different sizes and colors. It makes you Excel sheet more impressive and interactive.
Gauge :
The Gauge add-on for Excel 2013 shows speedometer visualizations in your Excel workbook.
Mini Calendar and Date Picker:
One of the simple apps that allow you to enter dates and calendar functions in excel very quickly and easily.
Radial Bar Chart:
This app shows your data in form of Radial Bar.
EPerfTool:
It is free enterprise modeling tool.
Sticky Notes:
You can create multiple notes with the help of this app. When you save Sticky notes, next time when you load this app is remembered by the app.
Percentage Calculator:
This app helps you to calculate all your percentage calculation.
QuickHelp Starter:
QuickHelp Starter has multiple videos about ‘how’ and ‘why’ any features added in Word 2013 and Excel 2013.
Sage Intelligence Go!:
This app helps users to access their accounting system’s financial data within Excel 2013.
.png)
Audible Charts:
This app helps to visualize data by hearing it.
Bing Dictionary
This app is an English language assistant for Excel and have powerful search capabilities that let users enter words as they sound.
Bing Maps:
It helps to use location data & plot it on a Bing Map.
MindMapper:
One of the impressive app that allows you to add structure to brainstorming sessions and visualize your ideas directly in your office applications
API Tutorial:
This App use to run and edit code in Microsoft Excel worksheet.
TextMaster:
This App use to correct & translated your text.
EasyInfoChart:
You can use this app to use professional quality charts in your excel sheets.
There are lots of other apps available for the Excel 2013 which you can easily download from Microsoft Store. Several Apps are also available for Word, Excel, Outlook and PowerPoint 2013.
App for Office= App Manifest + Webpage
Excel Apps is one of the best & most exciting feature of version 2013. These Apps allow you to add more additional functionality to your documents that provides more unified web-based extensibility platform for Excel. Microsoft added many different free & featured apps for Excel 2013 which you can easily download from Microsoft Store. You can use these apps in all Office 2013 and Office 365 versions like Home Premium and Small Business Premium. There are two types of apps available for Excel: Content apps and Task pane apps.
Content Apps: Content apps allow you to extend apps with custom content. These apps are embedded inside your worksheet and saved with it.
Task Pane Apps: We can use Task Pane Apps side-by-side with an Office document. While you are working in these apps, it opens a task pane on the right side of Excel Sheet.
An independent companies can also sell their apps if it works within Office. A company can easily post their Apps in the MS Office Store. If you also want to make your own app then You can make it easily by using following steps:
How to build Apps:
It covers three steps: Design, Develop, Publish
DESIGN: In this section, Microsoft guides you about design decisions that you will make and offer best practices to build your app.
DEVELOP: In this section, Microsoft provides in-depth overviews, how-to articles, and code snippets to help you in develop your app.
PUBLISH: If you built your app then you can easily publish apps in the Office Store.
How to Start an App:
You can start these apps in Microsoft Excel 2013 by using following steps:
First open Excel 2013:
Now Open Blank Workbook then click “Insert” ribbon.
Now on dropdown box “Apps for Office”. Click on dropdown arrow and click on the “See All”.
After click on “See All”, you will find all the list of Free & Featured apps.
Click on “OFFICE STORE” link after that you will see this window “Please sign in with a valid profile to see apps”
sign in with “Live ID”.
After log in, go to “Apps for Office” and click on “Office Store” link.
After that you will see apps. Click on required apps and then click on “Insert” button.
Apps will be successfully added into your Excel Sheet.
How to disable these apps:
If you want to disable an app for Excel then you can easily do it by hiding it. After that you will see that it is not showing in your apps list. Here are all steps:
First Click on Insert button & then App for Office
Click on Manage Apps
Find the app in the list that you want to disable & then click Hide
Now you can check your hidden apps: Click >>Show>>Hidden.
Some of the famous Apps:
Bubbles:
The Bubbles add-on for Excel 2013 shows worksheet data in form of bubbles of different sizes and colors. It makes you Excel sheet more impressive and interactive.
Gauge :
The Gauge add-on for Excel 2013 shows speedometer visualizations in your Excel workbook.
Mini Calendar and Date Picker:
One of the simple apps that allow you to enter dates and calendar functions in excel very quickly and easily.
Radial Bar Chart: This app shows your data in form of Radial Bar.
EPerfTool:It is free enterprise modeling tool.
Sticky Notes:
You can create multiple notes with the help of this app. When you save Sticky notes, next time when you load this app is remembered by the app.
Percentage Calculator: This app helps you to calculate all your percentage calculation.
QuickHelp Starter: QuickHelp Starter has multiple videos about ‘how’ and ‘why’ any features added in Word 2013 and Excel 2013.
Sage Intelligence Go!:
This app helps users to access their accounting system’s financial data within Excel 2013.
Audible Charts:This app helps to visualize data by hearing it.
Bing Dictionary
This app is an English language assistant for Excel and have powerful search capabilities that let users enter words as they sound.
Bing Maps:It helps to use location data & plot it on a Bing Map.
MindMapper: One of the impressive app that allows you to add structure to brainstorming sessions and visualize your ideas directly in your office applications
API Tutorial:
This App use to run and edit code in Microsoft Excel worksheet.
TextMaster:
This App use to correct & translated your text.
EasyInfoChart: You can use this app to use professional quality charts in your excel sheets.
There are lots of other apps available for the Excel 2013 which you can easily download from Microsoft Store. Several Apps are also available for Word, Excel, Outlook and PowerPoint 2013.
Age Calculator by Microsoft Excel !!
Often you may need to calculate your age. Or someone may ask you to calculate his/ her date. And sometimes you may need to calculate the difference between two dates. There are many third party tools (small software) to calculate the difference between the two days.
If youre using Windows 7/ 8 then you dont need any other tool to calculate the difference between two dates. Because Windows 7 and 8 has a nice calculator. It allows you to calculate age or date difference.
To calculate a date using Windows 7/8 calculator-
- Press Start + R > type calc > hit Enter.
- Now go to the View menu and choose Date Calculation.
- Now enter the From date and To date and hit on Calculate button.
Read More Here . . .
But my todays discussion is not this one. Today Im gonna show you how to calculate the age or the difference between two dates using Microsoft Excel! You just need to download a file and then open it. Download the file from the link below:
This is a zip folder. After downloading the folder, first you need to unzip it. There are 3 files:
- A Read Me file
- An xls file for Office 97-2003 users
- An xlsx file for Office 2007 and 10 users
Open the file that is compatible with your version of Microsoft Excel. After opening the file you will see some text as showing in the image above. Now do the following:
- Input current date in the day, month and year column.
- Input your birth date or the date from where you want to calculate in the day, month and year column.
- Now you get the difference or your age in the Age row.
Remember: Formulas used in this file for calculation are hidden. Never try to change it unless youre capable. If you make any mistake then it will not show you the correct result. If you wanna change the formulas, first you have to keep a back up copy of the file.
Hopefully this file will be very useful for you. If you wanna know about something or expect something from us, just leave a comment with your feedback/ opinion.
Thanks for visiting Marks PC Solution . . .
Stay with Marks PC Solution to get more interesting IT topics!
Recover Your Data from Corrupt Damaged Excel Workbook
-->
MS excel workbook may get corrupt due to several reasons.
These reasons could be:
1. It may be possible you can open the Excel file but data is corrupt.
2. File could not be open due to some disk error or network error.
If you are facing error as mentioned above then first you need to take the backup of your corrupt or damaged file before using excel recovery methods.
Once you take the backup of the file then you can follow these methods to recover your file.
Method 1: If File can be open: Apply below written method if you can open corrupt or damaged file.
Save your corrupt file in HTML format:
If you can open the corrupt MS Excel file, you can "filter" it and try to save it in HTML format, close the file, and then reopen it as follows:
- On the File menu, click Save As. In the Save as type list, click Web Page (*.htm, *.html).
- Under Save, click Entire Workbook, and then click Save.
- Close the file.
- Open the file again in Excel.
- On the File menu, click Save As. In the Save as type list, click Microsoft Excel Workbook. Change the name of the file to create a new "filtered" copy without replacing the original.
- Start Excel and open a blank workbook if one is not open on the screen.
- On the Tools menu, click Options.
- Click the Calculation tab.
- In the Calculation section, click Manual, and then click OK.
- On the File menu, click Open and try to open the file.
In minor excel workbook corruption cases you are able to recover data by any of above written methods. But in any case these methods didnt work for you then you need to use some advanced Excel recovery software to fix your problem.
Subscribe to:
Posts (Atom)