Technical Tips & Tricks

Problem: Outlook shows the message “we didn’t find anything to show here.” when looking in a folder that shows unread items. Cause The views in outlook can become unresponsive causing it to not display the emails. Solution Reset the view in outlook Open outlook and select the folder you are having issues with. On outlook ribbon click “View” Under current view category, click the Reset View Screenshot from Outlook 2013

Problem: How to add scanner button in word 2007/2010/2013. Solution: This could be tricky for a user because you have to add a script in word application. Let's see how. To add a Scan button into Microsoft Word: Click the Office icon in the top left. Click Word Options Tick the box labelled Show Developer Tab in the Ribbon Click OK. Click on the new Developer tab in the Ribbon Click Macros Type something in the top box and click Create Delete everything in the new box that pops up and paste in the following: Sub InsertFromScanner() On Error Resume Next WordBasic.InsertImagerScan End Sub Click File, then Save Normal, then close the Visual Basic Window. Click the Office icon. Click Word Options. Untick the Show Developer Tab button. Click Customize. In the drop down Choose Commands box and select Macros. Select Normal.NewMacros.InsertFromScanner. Click Add. Click OK. You should now have a new icon on the Quick Access Toolbar for Scanning.

Problem: When you right click on excel spreadsheet it do not show anything. Solution: 1. Open excel  2. Hit  alt-f11  to get to the VBE  3. Hit  ctrl-g  to see the immediate window  4. Type this and hit enter:        application.CommandBars("Cell").Reset       application.CommandBars("cell").Enabled = True 5. Hit  alt-f11  to get back to excel and test it out.

Problem : Microsoft Excel Error: "There was a problem sending the command to the program." Solution: If you are getting this error in office 2007 or 2010 then the solution could be simple then it it in office 2013. 1. Open excel 2007/2010. 2. Click on File Menu - > Options - Advance. 3. Under General Category you will find the option. "Ignore other applications that use Dynamic Data Exchange (DDE)” 4. Uncheck this option and close excel program. 5. Open excel and see if this will work otherwise you can also use other method described in other post on TechhStuff.  

Problem: exchange Server Error  "The connection to Microsoft Exchange is unavailable. Outlook must be online or connected to complete this action." Solution: Method 1: 1.Go to Administration Tools and open the "Services" tool. (You could also enter services.msc in the search box and press enter.) 2. Find the Exchange Address Book service and start it. 3. You can configure it to start automatically if you want. Method 2: By Deleting Reg Key from client computer: Remove the Group Policy or the system policy that sets the following registry entry: HKEY_CURRENT_USER\Software\Policies\MicrosoftOffice12\14\OutlookAutoDiscover Note: Take the registy back up before deleting any key.

Problem: Cannot print from office 2013 application. Solution: 1. open control panel and click on default programs or just search for default programs. 2. Make sure that word application should be there in the list. 3. if the application is not there and you can see other like excel,powerpoint. 4. Try to add word application in the list. 5. Right click on winword.exe(c:\program files(x86)\office 15\root\office 15\). 6. Select properties at bottom and make sure there should not be any box checked. 7.Try to make xps as a default printer from priter list. 8. Open services.msc in Run Window and restart print spooler service. Or otherwise uninstall the whole office app on your computer and reinstall it again.!!

Problem: How to password protect a PDF file in Microsoft Office Word 2013 Solution: 1. Open or create your document and click on the file menu, then click on Save As. 2. On the right hand side you will need to choose a location to save the password protected PDF. 3. Now drop down the “Save as type” box and choose PDF. 4. This will make an option button appear, click on it. 5. When the dialog box appears, you will notice the last option is to encrypt the document with a password, click this box. 6. Then you will need to create a password and click ok. 7. Now you can save the password protected PDF.