I have an Excel workbook which is protected by a password, so that when you try to open it in MS Excel it requires a password. I needed to transfer this file so it was an Apple Numbers file. Numbers cannot open Excel files that have password protection, so I needed to find a way to unprotect the document open it in Numbers and then save the document as a new Numbers file.
The help in Excel did not give me a solution, but eventually I worked out how it is done, and it is not a case of removing the password protection, here is how to do it.
1) Open the Excel file and enter the password.
2) Click 'Save As' to open the save as dialog.
3) In the bottom left hand corner click on the 'Tools' button.
4) Select 'General Options'
5) This will open a password dialog which will allow you to remove the password and save the file.
This solution makes sense and that once you have added a password on a file the only way of removing it is to save it as another file with the password removed.
Thursday, 9 May 2013
How to unprotect an Excel workbook
Labels:
2007,
Excel,
general options,
how to,
Microsoft,
numbers,
password,
protection,
remove,
save as,
spreadsheet,
tools,
unprotect,
workbook
Wednesday, 8 May 2013
Top Free Android Apps
I have been using my Nexus 4 phone for 3 months now, below is my list of my favourite free Android Apps, I have excluded the usual Facebook, Twitter and BBC News apps.
- Hotmail - View emails, I prefer this app over Google mail.
- IMDB - I use this app more than I thought, contains loads on info on any movie.
- Autotrader - View cars for sale
- Rightmove - Useful app if looking for property
- Wikipedia - Everyone knows this one.
- Nectar - View your balance and subscribe to special offers
- Task List - List of jobs and tasks that can be separated into different sesctions
- Real Racing 3 - great racing sim
Sunday, 5 May 2013
Broadband speed tests between Apple and Windows
The IPS I use at the moment is BT Infinity, which sells itself as a high speed broadband supplier. I thought recently I would try to check what speed I was getting
Below are some results of speed checking web sites. I concentrated on just the download speeds and on both iOS and Windows I used Google Chrome as the browser.
Speedtest.net
Apple - 37 mbps
Windows XP - 3.19 mbps
Android App - 14 mbps
BroadbandSpeedChecker.co.uk
Apple - 34 mbps
Windows XP - 3.38 mbps
I was surprised to see such a difference in the results. The results are the best I could archive and are not the average, but you can see a clear difference between Apple and Windows. I tried the speed tests on 2 different Windows XP machines and got similar results, so concluded at the time that it was not the hardware.
The following day, I looked at just using my Mac with a Windows virtual machine installed, here are the results:
Speedtest.net
Apple - 19.8 mbps
Windows - 17.8 mbps
BroadbandSpeedChecker.co.uk
Apple - 13.5 mbps
Windows - 5.9 mbps
You can see that the following day the speed was generally less, this could be the time of day and other factors, but these results are using the same hardware, just different operating systems to run the browser. Speedtest.net web site does seem to get very similar results, which would hint that different hardware (same router) could make a difference, but with BroadbandSpeedChecker it seems that different operating systems also make a difference.
In conclusion I think these speed testing web sites are a useful tool, however I am still not confident on how accurate they are and do not understand why Apple iOS gets such better results.
Below are some results of speed checking web sites. I concentrated on just the download speeds and on both iOS and Windows I used Google Chrome as the browser.
Speedtest.net
Apple - 37 mbps
Windows XP - 3.19 mbps
Android App - 14 mbps
BroadbandSpeedChecker.co.uk
Apple - 34 mbps
Windows XP - 3.38 mbps
I was surprised to see such a difference in the results. The results are the best I could archive and are not the average, but you can see a clear difference between Apple and Windows. I tried the speed tests on 2 different Windows XP machines and got similar results, so concluded at the time that it was not the hardware.
The following day, I looked at just using my Mac with a Windows virtual machine installed, here are the results:
Speedtest.net
Apple - 19.8 mbps
Windows - 17.8 mbps
BroadbandSpeedChecker.co.uk
Apple - 13.5 mbps
Windows - 5.9 mbps
You can see that the following day the speed was generally less, this could be the time of day and other factors, but these results are using the same hardware, just different operating systems to run the browser. Speedtest.net web site does seem to get very similar results, which would hint that different hardware (same router) could make a difference, but with BroadbandSpeedChecker it seems that different operating systems also make a difference.
In conclusion I think these speed testing web sites are a useful tool, however I am still not confident on how accurate they are and do not understand why Apple iOS gets such better results.
Labels:
Apple,
broadband,
BroadbandSpeedChecker.co.uk,
Google Chrome,
iOS,
mac,
mbps,
speed,
Speedtest.net,
test,
Windows,
XP
Monday, 29 April 2013
01792211844 Annoying calls to new phone
I recently bought a new phone (Nexus 4) and have not given out the details to anybody, except Apple. Today I received an annoying automated call informing me of money I could possibly be owed (PPI insurance most likely). This was obviously some sort of scam, but how did they get my number? There are 2 companies which I have allowed to know my number intentionally, which are Apple and of course my phone supplier Vodafone.
After looking into who might have my number, which now seems to be anyone, my conclusion if that my phone number has been retrieved from one of the apps I have downloaded recently. These apps can access my phone information and send it back to the company or individual, then they will sell it on. So these free apps from android can take information from your phone and sell it on.
Here is a list of possible suspects
After looking into who might have my number, which now seems to be anyone, my conclusion if that my phone number has been retrieved from one of the apps I have downloaded recently. These apps can access my phone information and send it back to the company or individual, then they will sell it on. So these free apps from android can take information from your phone and sell it on.
Here is a list of possible suspects
- Lazors
- Flow free
- Real Racing 3
- Logo Quiz
It could be none of these, but somehow someone has got my new phone number and sold it on.
Labels:
01792211844,
07860034505,
4 pics 1 word,
annoying,
Apple,
calls,
flow free,
Lazors,
logo quiz,
real racing 3,
Swansea,
vodafone
Thursday, 18 April 2013
Screen Capture MAC
I use both Windows and Apple computers and I needed to find the best way to capture an area of the screen on my iMac. I thought I needed something like Cropper which I use in Windows, but have discovered iOS has it built in. Here are the following capture options I have discovered:
- To capture an area of the desktop, press cmd+shift+4, this will give you a cross hair where you can select and area of the screen, this will save the image as a png file on the desktop.
- To capture a application screen, press cmd+shift+4, to display the cross hair again, now hit the space bar and the icon will change to a camera and will select areas of the desktop.
- To capture the whole desktop, press cmd+shift+3.
Sunday, 14 April 2013
How to Access Android files on Mac
I recently purchased a Nexus 4 phone, over the past couple of months I have been taking photos and video and wanted to transfer them to my iMac. I thought I would simply need to plug in the phone into the USB port and it would see the files, this is how it is done on Windows PC. At first I was a bit worried that because it was not Apple, and I had an awful feeling it would not work. But after doing some research all you need to do is download the Android File Transfer application, install it and you can see the files on your Nexus 4 phone.
Friday, 5 April 2013
Pomodoro technique using RicRac Stopwatch
As a software developer I have been looking at possible ways to increase productivity, recently I have spent a couple of days looking at the time management technique called Pomodoro. The basic process is to do increments of work which last for 25 minutes and then have a 5 minute break these are called pomodoros, then after 4 pomodoros you take a longer break of about 20 minutes.
To do this I downloaded the RicRac Stopwatch, installed it and made a second copy by coping the directory, this then gave me 2 copies which I could have 2 different settings for, the first with a 25 minute countdown and the second with a 5 minute countdown. RicRac stopwatch worked well doing this, the issues I had was with the technique itself, my main criticism of the technique is that I work in an open plan office, and people constantly interrupt, which breaks the increments. For this technique to work I think I would need to be in a quite office or work from home.
Wednesday, 6 March 2013
Nexus 4 battery problem
The other day my Google Nexus 4 phone had a battery charging problem. I put the phone on charge with 43% remaining and after a few hours maybe up to 5 the charge was only up to 45%. Taking it off charge and looking at the usage it dropped back down to 44% within a minute. I thought I was in trouble and there was a physical problem with the battery. The solution was to completely turn off the phone and switch it back on, then it started charging fine and I've had no problems since. The only thing I can think of that could have caused a problem is either the number of apps running or a specific app that causes a problem, will keep an eye on it.
The Nexus is not great when it comes to keeping its battery power and I have to charge mine on a daily basis. Here are some tips on improving the charge of the battery.
The Nexus is not great when it comes to keeping its battery power and I have to charge mine on a daily basis. Here are some tips on improving the charge of the battery.
- Switch the NFC and Bluetooth off when you don't need it.
- Turn off App syncing when you don't need the App to be synced.
- I've chosen a dark background to try to reduce brightness.
- Apps that have the option to change the background colour I've set to black.
- Check the battery usage and see what areas could be improved.
Subscribe to:
Posts (Atom)
