Pages

Friday, December 4, 2015

How to Use Data Validation in MS Excel

MS Excel has huge number of users over the world and these numbers are increasing day by day because every time it comes with new features. People use the excel sheet to maintain the data in a good manner. Have you ever tried to apply the validation on the cell? If your answer is no, then read this blog to know about validation option in MS Excel.

Suppose, you want to set the validation (restriction) on a cell that, when someone is trying to enter a data which is more than 15 characters or against the validation then, it will throw an error in the screen to warn the user.


Steps to add validation:

Step 1: Click on the Data tab. Unser the Data Tools option, Data Validation option is available.


Step 2: Now select the cell which you want to validate. Click on the Data Validation option. When you will click on this option then, a window will appear on the screen with the different validation option. This window looks like this:


You can see the different validation options in this window:
  • Setting
  • Input Message
  • Error Alert
Setting: In this option, you can choose the different options for the validation like: Text, Decimal numbers, Date, Time, List and Whole number etc. I am choosing the Text length option from the list and set the minimum value is 1 and the maximum value is 10.



Click on the OK button.  Now try to enter the data in the cell. 

Input Message: If you want to show the message on the cell at the time of entry then, you can choose this option. It’s not a mandatory option. This section has two fields: Title and Input Message. Just write the message and click OK to save it.


Error Alert: With this option, you can create your own error message. Enter title and message according to your validation. It has three symbols: Stop, Warning and Information. 


It is the Stop message. You can try the other option by selecting them from the list.

Conclusion: We have seen the different data validation options. Always choose a meaningful title and message which explains the validation and restrictions perfectly. This is the easiest way to create the error messages in MS Excel.
READ MORE - How to Use Data Validation in MS Excel

Sunday, November 29, 2015

Know More about AutoSum option in MS Excel

Today, when I was working with MS Excel then I used the AutoSum option many times to make sum of the numbers. I have noticed one thing about this option which was very interesting. This option is available in two places, first in Home tab and second in Formulas tab. Check the images below:

 
   AutoSum in Home Tab                                           AutoSum in Formulas Tab

Shortcut for AutoSum:

In MS Excel, every formula and function have its own shortcut. You can use ALT+ as the shortcut of AutoSum option. To test this option, write down the numbers in the excel sheet and press ALT+ to make its AutoSum. Now I am describing my experience with this function.

First I have created three columns named: Physics, Chemistry and English. Now I entered some numbers along with the columns.


Test of AutoSum Option

Vertically Up: Excel user may use‘=sum(number1,number2)’ formula or AutoSum option to sum-up the data. When I tried the AutoSum option in vertically up then it gives me the following result:


After this option, I pressed the Enter key to get my answer. The answer was correct.

Vertically Left: In this situation, I have selected the value of a single row and apply the AutoSum on it.I found the result like this:


I pressed Enter key and got my answer.

Vertically Down: Now, I was trying to test the AutoSum vertically down. In this case, the AutoSum option was not proving the range of the data cells. Check the image below:


So this is the one limitation with AutoSum option.

Vertically Right: The AutoSum option was not working in this situation. When I tried, then I got only the formula, not the range of numbers. Take a look:


So, Thing option doesn’t work in this situation.

Blank Cell in Numbers: If you have the blank cell in the numbers then, the AutoSum option will not take the values before it. This is also a limitation of this function.


So, we have seen the AutoSum function in the very different levels and the limitations of this function. I hope you like it. If you have more information about it then please share with me.
READ MORE - Know More about AutoSum option in MS Excel

Tuesday, November 24, 2015

Prevent Your Excel File by Automatic Creation of Hyperlinks

A hyperlink is important but in few cases it becomes tedious. Automatic creation of hyperlink is like a speed breaker in the document creation process. It creates with the following prefixes:

  • http:// 
  • ftp://
  • file:
  • www.
  • mailto:
  • news:
  • \\

Suppose, you are working with large the number of excel files and each file consists of thousands of hyperlinks then what will do? I think you will try to remove manually but here, we are talking about thousands of hyperlinks. In this case, try these options:

Apostrophe (‘) at the starting of the cell entry: To understand this option. Let’s take an example. Suppose you are trying to write www.google.com in the cell. When you write it then, it becomes hyperlink automatically. In this case, write an apostrophe (‘) at the beginning of the cell entry.
‘www.google.com 
It won’t become hyperlink. This is the first way to prevention of automatic hyperlink. The second option is more interesting which is given below:

Using autocorrect options: Simply follow these simple steps:

  • Go to the File-> Options -> Proofing -> Auto-Correct Options.
  • Click on the AutoFormat As You Type.
  • Uncheck the option “Internet and network paths with hyperlinks”


Using Macro: If you have the coding skills then you can easily try this method and if you are doing this first time then follow these steps:
  • Open the excel file and press Alt+F11 to start the visual basic editor.
  • In the left hand pane, you can see the worksheets of the excel files.



  • If you want to remove the hyperlinks of Sheet1 then double click on it.
  • Now, write the following code using project explorer:
  • Sub RemoveHyperlinks()
    ActiveSheet.Hyperlinks.Delete
    End Sub 


  • Save the file.
  • Go to the excel sheet, Press Alt+F8 to run the macro. Click on the run button.

  • All the hyperlinks will be deleted easily.


Using paste special option: Paste special option is also used to remove the hyperlinks. Follow these steps:
  • Write 1 in a blank cell.
  • Copy the cell.
  • Select the cells with hyperlinks.
  • Now select the Paste Special.
  • Choose the multiply option.


  • Click OK.

Now the hyperlinks will be deleted off the selected range.
Note: This option will not work MS Excel 2007 and the previous versions. 

Final words: MS Excel does not provide any built-in method to fix this problem. In this article we have seen four methods to remove the automatic hyperlinks.   

READ MORE - Prevent Your Excel File by Automatic Creation of Hyperlinks

Monday, October 19, 2015

Header Corruption of PSD File

Adobe Photoshop is the perfect tool to create images and it is used by professionals as well as home users. Photoshop files or the layers sometimes for no apparent reason gets corrupted and refuses to open. As a result of the numerous situations like: sudden power failure, interruption while downloading and virus infection etc; can damage or corrupt the Photoshop files. In this blog, we will discuss the header corruption in .PSD file and solution to overcome from this issue.

Header of any .PSD file contains all the vital information about PSD file such as size, colors, number of layers and other important details. When the header got corrupted of the Photoshop file then the operating system or other tools cannot access that file.

Points to remember: The header can corrupt by the following reasons –

  • Memory in the bad sectors where the .PSD file is located. This memory works as storage device. system hard drive works as a storage device.
  • Improper termination of the Adobe Photoshop application during editing process of the file. It can damage the file header.
  • Malware attack is also the main reason for corruption in .PSD header.
  • Incorrect way to compress the .PSD file can also be the reason of its header corruption.
  • CRC (Cyclic Redundancy Check) during transferring the image on the network is also a reason for header corruption.

Header corruption of the .PSD file is very critical situation for a user and it makes user helpless.In this situation, a third party utility like Stellar Phoenix PSD Repair can be the life saver. This tool is tested by professionals and repairs the .PSD file without difficulty. It also supports .PSB and .PDD image formats and repairs these files.

Tool Interface: This tool has a very clean interface which makes it more users friendly. When user downloads this tool and open it then, below window will appear on the screen:


You will get two options to choose from the drive: 
  • Select file
  • Search File

These options are shown in the below image:


Choose the file according to requirement and click on the Scan button. This tool will repair your corrupt .PSD file within few seconds.



Final Words: Header is the very important part of the .PSD file because it contains behavioral information of the file. We have seen the main reasons for header corruption of a PSD file and a tool which can repair these files very easily. 
READ MORE - Header Corruption of PSD File

Monday, September 21, 2015

Important features of MS Excel 2016

MS Excel 2016 is more enhanced with its feature. For windows and OS X, MS office 2016 will release tomorrow (22-Sept-2015). You can easily download its preview from the official site and they are also providing the product key for office 2016 preview. This preview will be available on your system until you uninstall office 2016 preview or office 2016 is released. So get ready to know about few of them like Power-Query and Business Analytics. Read this post to know about them.


Power Query

Power query is not a new feature for Excel users but this time it is more integrated and available as an inbuilt feature of MS Excel 2016. This feature is available in Excel 2010 and 2013 as Add-in. In MS Excel 2016, this feature is available in Get & Transform section which provides fast, easy data gathering and shaping capabilities.























Image courtesy: Microsoft

I will discuss some important feature that you can achieve with power query in Excel 2016:

Data Connectivity: This feature is more updated in Excel 2016. It also helps to combine and filter the data. Now you can easily connect with the new data sources like Facebook and Salesforce to import the data. This is the new change in MS office 2016. As previous versions it also imports data from Files, Database, and Azure etc as shown in the figure:



Data Shaping: Query editor is the most significant feature of this new release. You can easily see the preview of your data and perform modification such as remove, pivot and unpivot columns with the help of query editor.

Data catalog: You can use this option to find the data according to your requirement. This is possible by the power BI enterprise catalog. To use this, you should have the power BI license.

Business Analytics

Any result is based on the analysis factor and it should be clear from the beginning of the project. Take a look on the following process:

Let’s discuss some features of business analytics of MS Excel 2016.

Modernized Data Analysis: Data analysis always plays an important role for every project growth. This feature is wonderfully enhanced in Excel 2016.Now you can be more focused on uncovering the insights rather than managing your data. I read about automatic time grouping and drill-down chart navigation feature to improve the usability. You can see them on below image:


New and Improved Charts: With this option, Excel 2016 has fined the new idea to expand the visualization of data by improvement in charts. It has the new set of modern charts with a consistent look and feel. With this option, you can easily understand the percentages of data. See the most useful charts, waterfall and sunburst in the image below: 


Excel Forecasting Function: You can feel the best experience of forecasting by FORECAST.ETS() function. You can see some reasonable results on the image below:


Sum Up: Power Query and Business Analytics are very interesting features in MS Excel 2016. Efficient data connectivity will make data importing more easy and by the use of query editor, user can shape the own data according to need. Similarly, Business Analytics feature will make your work easy in a graphical manner. 
READ MORE - Important features of MS Excel 2016

Sunday, August 16, 2015

Repair .PSD file in Few Simple Steps

Adobe Photoshop does not need an introduction because it is used by millions of people across the globe and available in the 25 different regional languages including English. This great tool is available in the market from last 25 years and growing day by day.You can read more about of this tool on Wikipedia. It has a very big market of the customer from the different fields but, sometimes you can face the corruption problems in your .PSD files. The sad news is, Adobe does not provide any tool to repair corrupt .PSD files but luckily few data recovery companies (like Stellar data recovery) provide tools to repair these corrupt files. To know about these tools, stay with this blog.

PSD recovery tools are very powerful and able to repair the layers of .PSD files. This kind of software can repair the various file formats and it can be found as free and paid. I have tested many tools before writing this article. I found these tools are good and appropriate for .PSD repair. Take a look on these tools:




When I clicked on OK button then saw the error “file is not compatible with this version of Photoshop” then I click on the cancel button.

I downloaded this tool to test its working process because I was looking for one of the best .PSD repair tool. After completion of the downloading process, I run it on my machine and saw its GUI.



As you can see in the above image, you have two options to choose the corrupt file. I know the path of my corrupt file so I have chosen the Select File option and click on the Scan button. This tool was showing the preview of my corrupt .PSD file and all information like length, width, bits, horizontal pixels, vertical pixels in the log report. 



User can save the log file by clicking on the red bordered button on the top. You can save this report and it looks like this:


As it was a demo version of the tool so I was unable to save my repaired file. To download its full version I registered the software and use it.

Advantages:
  • It is repairs .PSD, .PSB and .PDD files.
  • It is safe and secure.
  • Shows the preview of repaired file.
  • It has a log file status of the process.
  • Valid for life time.

Disadvantages:
  • It is a paid tool ($39 only).
  • It has only single user license.
Third party tools works in many cases but I am not full confident on them. Sometimes they create more corruption in the files so choose the recovery tool very carefully.

Telegraphics Online PSD Repair:This is the free online tool for .PSD file repair by telegraphics. Upload the corrupted file and repair it by one click. See the image below:


From the above image it is clear that, this tool saves the layers of .PSD file in .PNG format. It is very helpful when user does not have Photoshop.

Advantages:
  • It repairs .PSD or .PSB files.
  • Maximum file size support limit is 200MB.
  • Layers are collected in png files or together in a ZIP archive.
  • If you want to repair a file more than 200MB on your system then, you can use its plug-in.

Disadvantage:
  • It is an online tool so files are automatically deleted from the server after 24 hours after processing.
  • It is not secure for confidential files.
  • Limitation in file size (200 MB).
  • Sometimes unable to repair files.
  • It depends on internet connection.
Conclusion: In this blog, we have seen two different tools for corrupt PSD file repair. Both has advantages and disadvantages over one-another. At the end I will suggest the first tool for those users that gives the preference to the security and privacy and second tool is good for those users that are looking for a free tool to repair for .PSD files.
READ MORE - Repair .PSD file in Few Simple Steps

Thursday, July 30, 2015

Top 5 Solutions to Repair Corrupt PowerPoint File

PowerPoint is a very well know tool that comes as a part of MS Office suite. Often people use it to create presentations for different purposes. Generally, PowerPoint files are larger in size and have a complicated file structure due to which they are prone to corruption. It takes a lot of efforts and hard work to create a PowerPoint presentation in MS PowerPoint, but due to corruption it could be useless.



Like every other computer file, PowerPoint presentations can corrupt or also become inaccessible at any time. When a corrupt PPT file starts sending you error messages while opening, it is an indication of corruption, which could be major or minor. Let's check out some common solutions that you can perform on your corrupt PPT files in order to repair them or to retrieve the content.

Solution 1
You can simply move the corrupt PowerPoint to a different location. This is a very simple and useful way to troubleshoot your corrupt PPT file and remove its problems. You can also do it by copy and paste the presentation file on an another hard disk.

Solution 2
In case the above mentioned solution has not resolved your problem, then you can try to open the PPT file in MS word format. Follow the below mentioned steps to do it:

  • Open MS Word document.
  • Go to the File menu and click on Open button.
  • Choose files of type box and navigate to your corrupt file, Open it.
Solution 3
You can also try to open your PowePoint file in Safe Mode. To open your PPT file in safe mode, first you need to run PowerPoint in safe mode. Steps to open a PowerPoint application in safe mode.

  1. Go to Start button.
  2. Choose Run & type 'C:\Program Files\Microsoft Office\MS office version\Powerpnt.exe" /safe'.
  3. Click on OK button.
  4. Now, restart your system in safe mode. To do this run your Windows by holding F8 button.
  5. Open and check your presentation.

Solution 4
Follow the below mentioned steps:

Steps to repair PowerPoint 2010 / 2007

1.      Open a fresh presentation in MS PowerPoint.
2.      Save the presentation.
3.      Now, go to Home tab.
4.      Go to Slide and select Reuse Slides from the drop-down.
5.      Select the Browse button and select a file by selecting Browse File.
6.      select your original PowerPoint file and Open it.
7.      Now, go to Reuse Slides panel, select the Keep source formatting check box.
8.      Right click the first slide in the Reuse Slides panel and choose Insert All Slides.
9.      Save the new presentation and run it again.

Steps to repair PowerPoint 2003 or earlier

1.    Open a fresh PPT file.
2.    Select Slides from Files from the Insert menu,.
3.    Now, browse to your original PowerPoint file from the Slide Finder dialog box.
4.    Choose the Keep source formatting check box.
5.    Select Insert All.
6.    Save your presentation and run it again.

In case the above mentioned method is doesn't work for you, then you can also try the following steps:

1.    Run the PowerPoint file in question
2.    Now, go to File > Save As and choose the type of Web Page (.htm, .html).
3.    Save the file in the same location as your file.
4.    Close PowerPoint.
5.    Now, run the html file in PowerPoint.
6.    Again, go to File > Save As and chose the file type Presentation (.ppt). click Yes, when prompted, it is to overwriting your previous file.
7.    Close it, and run again.

Solution 5

In case none of the above mentioned processes have failed to fix your corrupted presentation, then the only option you are left with is professional utility. Third party tool is the most reliable and recommended way to repair even a deeply corrupt PPT file. There are various PowerPoint repair software available, you just need to choose one and perform recovery process.
READ MORE - Top 5 Solutions to Repair Corrupt PowerPoint File

Thursday, July 23, 2015

How to fix BEX error in Word, Excel and PowerPoint

BEX error is a very common, which occurs due to buffer overflow problem. This error comes with many parameters and user gets an error message on the screen “Application_Name has stopped working”. In this blog, I will give you the solution of this problem for MS Word,Excel and PowerPoint. Take a look on the error message:

Above image shows the BEX error for MS Word.

When a user will click on the “View problem details” option then, a detailed error message will be appear on the screen.

In the above image, Problem Event Name is BEX and second parameter is Application Name and so on. You can read more about these parameters from this article https://technet.microsoft.com/en-us/library/cc738483(WS.10).aspx

General solution of the problem

Here I am giving the solution for MS Word but, it is same for Excel and PowerPoint as well. Open MS Word in the safe mode and click on the File option. At the bottom end, user can see the Options as shown in the image below:

Now in the Options category, User can see the multiple options like General, Display, and Language etc. Add-Ins option is also available with these options. When a user will click on the Add-Ins option then, in a right pane a user can see the option to manage Add-Ins. 


Now Select COM Add-Ins and click on the Go button.

Once a user will click on the Go button then, a COM Add-Ins Windows will appear on the screen. Every Add-Ins has a check box which represents the availability of the Add-Ins. In the below image, first Add-Ins is a COM Add-Ins. Uncheck this option and click on the OK button.


Now close the application. Run the application in a normal user mode. This time user will not get this error.

Conclusion: This is very simple and easy way to solve this problem. Any user can follow these steps to solve this error whether a user is technical person or not. I hope this blog will help the users to solve this problem.
READ MORE - How to fix BEX error in Word, Excel and PowerPoint

Monday, July 20, 2015

MS PowerPoint – How to fix the error "PowerPoint can’t open of file"

Just think of it!! Whole night you spent in creating PPT for next day meeting but, when you try to open the file at office it says “PowerPoint can’t open of file represented by C:\Users…..” so, what will you do? This is only one situation which I have discussed to you. A user can face the many worst conditions with MS PowerPoint error. As a blogger and reader I always give the importance to PowerPoint presentations but I also faced corruption in the .ppt or .pptx files. In this article, I will discuss the solution to recover from PowerPoint corruption.

There are following ways to solve the problem of MS PowerPoint error:

Move the file to another location:

This is the first solution that, I will suggest to all users. Every program has a default location to save its programs. User can also choose the location to save that file. If user is getting this problem repeatedly then move the .PPT/.PPTX file on the different location and reopen it.

Unblock the file:

Every file has block and unblock option. When a user downloads the PowerPoint file from the web then, it comes with block option. User has to unblock the file to fix this issue. To unblock the file, simply follow these steps:
  1. Right Click on the PPT file then, click on the properties.
  2. In General Setting, User can see Unblock option in Attributes and Security. A message is also presented on this section “This file came from another computer and might be blocked to help protect this computer” which means file has been downloaded by the external source.
  3. Click Unblock then OK.


Reuse the slides: 

Microsoft PowerPoint gives the flexibility to reuse the slide from one presentation to another presentation. Create a new blank PowerPoint presentation and reuse the slides from corrupt file. In Office 2007, click on the Home Tab then go to the New Slide option as shown in the Image. At the bottom side, User can see the option of Reuse Slides. Click on this option. 


Now click on the Browse option to select the PPT and reuse the slide.


Repair MS Office:

MS office has an in-built function to repair the application. Simply go to Control Panel->Programs -> Programs and Features.  Select the MS Office from the list then click on the Change option.


Now quick repair the program and open your PowerPoint presentation file.

I have discussed some simple techniques to solve the MS PowerPoint error. Try these options to fix the error.
READ MORE - MS PowerPoint – How to fix the error "PowerPoint can’t open of file"

Tuesday, June 30, 2015

Quick Fixes for Microsoft Excel Has Stopped Working

In the spare time, I love to participate on forum websites and Office related issues are my favorite topicfor discussion. I saw that, many Excel users facing the same error “Microsoft Excel has stopped working” and they feel very helpless so, I decide to write a blog about this problem. In this blog I will give the solutions to overcome from this problem. If this happens with you then stay with me for half an hour!


User gets above error message on the screen during this problem. Try these options to resolve this problem:

Solution 1: Run MS Excel in Safe Mode

This is the first option that, every excel user should try to solve it. Simply press Windows+r to open the command prompt or open from the Run option in the Start Menu. In command prompt user has to type excel.exe /safe to open the MS Excel in the safe mode. Press the Ctrl button and open Excel file is another option to use the safe mode.


Solution 2: Check the Add-ins

Go to the File Menu then click on the Excel Options.Now in Excel Options window, Add-ins option is available in the left-hand side. In the below image, you can easily see the Active Application Add-ins list in the window. Every add-ins has its name location and Type which has been mentioned in the list. In this example the Type of this Add-in is COM Add-in.


























Now go to the Manage option, which is available in the bottom and set COM Add-ins. Click on the GO button.

A COM Add-Ins dialog box will appear on the screen. In the above image, first option is checked as right. Uncheck it and click OK button.
















After successful completion of this process, users can be easily open their Excel file.

Solution 3: Repair Office 2013

It is also very useful option to solve this problem. Go to Control panel and select the Microsoft Office from the list as shown in the image. Shortcut to open control panel is so simple, Go to command prompt and type appwiz.cpl and press enter.






















Now click on the Change option as shown in the below image.






















When a user will click on the Change option then an office window will appear on the screen. Choose Quick Repair option and click on the Repair button. Now user can see the repairing process on the screen.











































When repairing process completes a confirmation message arises on the screen. Click on the Close button and open the Excel file.






















Solution 4: Start the Application as Administrator

User can easily open any application like the administrator. In Windows 7, Right Click on the application and choose Run as administrator option. In Windows 8, Click on the windows button and select the application. At the bottom ends, Run as administrator option will be available. Click on this option and use it. In the below image, this option is available in the blue bar. 






















Solution 5: Keep your Windows Updated

It can also be the reason for this error. If any latest updates are available on the web then update your application. Sometimes any missing update creates this problem. So always update your application if it is recommended. To update your application, follow these steps: 
  1. Click on the Start button and go to the Control Panel.
  2. Click Systemand Security.
  3. At the Windows Update option, click on Turnautomatic updating on or off.
  4. Now Choose Install updates automatically (recommended) option or Check for updates but let me choose whether to download and install them option.
























Conclusion:

In this blog we have seen the different solutions to solve the MS Excel error Microsoft Excel has stopped working” and I am not sure that, these are the enough solutions for this problem. I will suggest to all readers, try all these options to resolve this problem.  
READ MORE - Quick Fixes for Microsoft Excel Has Stopped Working
Related Posts Plugin for WordPress, Blogger...