Selecting only visible cells in Excel

I found a neat solution to a problem I have manually been working around for quite sometime.

If you have hidden any rows or columns in Excel and want to copy the remaining data only, or if you have made use of the outlining tool and have created subtotals in your document and you only want to copy those subtotals then you can do so by following these steps;-

1. Select the data you want to copy
2. Press Ctrl+G to bring up the "Go To" window
3. In the bottom left corner click the Special button which will bring up the "Go To Special" window
4. From this window select "Visible cells only" 
5. Click OK

Now copy and paste the selection as you normally would.

Creating a sent item in Outlook without sending it

I was asked if it was possible to create an email within Outlook and make it look like it had been sent, without actually ever sending it. This question is very much in the grey area of "Don't ask why?"

After rummaging around on the Internet I couldn't actually find a reliable answer, but I remembered doing something similar with the nickname (.nk2 file) 

1. Open Outlook
2. Click File - Manage Rules & Alters
3. Click Next
4. At the bottom of the window under Start from a blank rule, select 'Apply rule on messages I send'
5. Click Next
6. Tick the box that says 'sent to people or public group' then in the bottom window click on the underlined text 'people or public group'
7. In the To box enter the email address you are sending to then click OK
8. Click Next
9. Tick the box that says 'move a copy to the specified folder' then in the bottom window click on the underlined text 'specified'
10. Select Sent Items and click OK
11. Click Next (twice)
12. Click Finish
13. You will be warned that this rule will only run when Outlook is running, click OK (twice)
14. Either Disable your wireless / Internet connection OR put make Outlook Work Offline.
15. Create a new email and send it.
16. As Outlook is offline the message should stay in your Outbox. Scroll through your folders until you find the Outbox, it should show that 1 message is unread. Click into the Outbox and then delete the email contained within.
17. Navigate to your Sent Items, this should also show 1 unread item which is the email you have just 'sent'
18. If you want to modify the date on a sent item then you can do so by modifying the date / time on your computer. 


I am currently still searching for a simpler solution, and am also looking out for some sort of add-in that may just create the sent object automatically without having to go thorough the steps outlined above

Word / Office 2013 has stopped working

Annoyingly if you look around the web for Word / Office crashing on start up or "has stopped working" you will find thousands of posts all recommending the same thing; start word in safe mode and then disable COM Addins. 

After trouble shooting the issue for 3 hours and trying a variety of things I finally managed to resolve my problem. It seems my users issue was to do with their USB docking station (and the version of the Display link Adapter software they had installed)

I guess I could try upgrading the version of the software, but the user works in a different country so I don't want start uninstalling anything that may cause me to be disconnected. To get them up and running I was able to disable hardware acceleration for office, to do this

Run Regedit
Go to HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common
Create a new Key called Graphics
Under the new key create a new DWORD called DisableHardwareAcceleration
Set the DWORD value to 1

Office 2010 Activation error 0x80070190

An unspecified error has occurred. Your request cannot be processed at this time. Please try again later. (0x80070190)

I’ve had the above error message a bunch of times while trying to activate Office 2010, I’ve been able to work around the problem by using the telephone activation option provided by Microsoft but it’s a pain and takes about 5 minutes. I honestly can’t believe I’ve put up with problem for so long when the solution to my problem was fairly obvious and straight forward.

If you are dealing with this error try running the activation as Administrator (right click Word or Excel and select Run as Administrator)

Worked first time for me.

Outlook 2013 New Feature

I’ve started upgrading a few people from Outlook 2007/2010 to 2013 and have come across a new feature that’s really going to help out some of my users.

Some of my users have mammoth mailboxes, one in particular is at 20GB. Outlook in cached mode routinely slows up and the only explanation that we can reach is that Outlook must be doing some routine maintenance on the OST. It became so unusable that we turned off cached mode for that user. The answer is to obviously delete and archive email but some users are stubborn.

We did switch off Outlook caching, but now we find that when the user is going in and out of folders etc that Outlook will hang for a few seconds, its quite frustrating.

Anyway onto Outlook 2013, under account settings there is a now a slider titled “Mail to keep offline” it ranges from 1 month, 3 months, 6 months, 12 months and all. 

Excel cannot complete this task with avaliable resources.

 

 

If You've ever come across the above error when trying to open an Excel workbook ("Excel cannot complete this task with available resources. Choose less data or close other applications") then you can resolve it by increasing its priority in Windows.

 

 

With Excel still running, open task manager and locate the Excel.exe process, right click on it and navigate to priority, normally it should be set to normal, if you increase this to "Above Normal" you should be able to open your problematic workbook. I am not sure of the underlying cause of this and I've only seen this problem when running Excel 2010, it is defiantly not a hardware/resource issue.

Outlook 2010 - Finding a misfiled email

Every so often I get a phone about finding lost or misfiled emails. Normally the user has accidentally dragged the email to a folder and misfiled it.

Luckily the search facility in Outlook 2010 is pretty good.

Click on your Inbox and then into the "Search Inbox" field. The toolbar at the top of the screen should now display some search options, the default is to search "Current Folder", change this to "All Subfolders"

99% of the time this will find the email I am looking for. Sometimes the user will want to know what folder the email was misfiled in, simply double click on the email and then click on the File tab. Under the "Move to Folder" option it should display "Current Folder: "

PowerPoint 2010 video problems "Microsoft Office PowerPoint Has Stopped Working"

I encountered a frustrating problem today, I’ve still not really worked out a “final” solution but here’s what I discovered.

A user has a number of power point presentations with videos linked (possibly embedded within) the videos are of mixed format.

The videos and presentations run perfectly on their laptop but on their assistants they do not. In fact on their assistance laptop Microsoft PowerPoint crashes when you try and open the presentation with the following error message “Microsoft Office PowerPoint Has Stopped Working”

I was able to open the presentations with PowerPoint 2003 (using Microsoft Compatibility pack), the base files are in 2007 format (.pptx), if PowerPoint 2003 won’t open the pptx file and you have the following error “No text converter is installed for this file type” simply download service pack 3 for Office 2003.

So people have suggested that once open in 2003 that you could try saving the file as a ppt, this works however I am concerned about what video functionality we may lose by doing this.

I found that by uninstalling VLC media player that I could now open the presentations in PowerPoint 2010 however I am unable to view any of the videos nor am I able to view any of the video properties. I managed to fix this by installing an earlier version of VLC media player (I opted for version 1.0.0 available from VLC’s ftp site http://download.videolan.org/pub/videolan/vlc/)

It seems that the videos in this presentation are “linked” a new feature in 2010 is embedded videos, I think I will investigate this and see if embedding the media resolves this issue.