Archive for the ‘Excel’ Category

Excel Pivot Table – Data source reference not valid

Feb 22

If you have are trying to create a pivot table and are getting the error “Data source reference not valid”  It’s ususally caused by excel sheets with square brackets in the title [ remove these and it should work fine]  

Keep Reading

Store mobile numbers in Excel

Nov 19

When storing mobile numbers in excel you will often find that unless you put a ‘ in front of the mobile number (Storing it as text) Then the 0 at the start of the number will disappear. Heres my solution

Keep Reading

How to store phone numbers in excel

Jul 31

When storing phone numbers in excel you will generally find that unless you put a ‘ in front of the number (Storing it as text) The 0 at the start of the number will disappear. Heres my solution Get your own valid XHTML YouTube embed code How to store phone numbers in excel

Keep Reading

Rotate a table in microsoft excel

Jul 7

To rotate a table in excel 90 degrees

Keep Reading

Destination reference is not valid in pivot table wizard

Dec 6

I was getting the following error in Excel 2010 today while trying to prepare a pivot table. “Data source reference is not valid” When I copy and pasted the data into an entirely new worksheet it worked fine. The original spreadsheet was downloaded from the internet and it seems that excel throws up this error […]

Keep Reading

How to remove the password from an excel sheet

Dec 1

If you have an excel sheet you’ve manged to forget the password for dont panic its easily fixed: Firstly open the spreadsheet and go to the VB editor Paste in the code below and close the VB editor Go to the ‘View’ tab and ‘View Macros’ You should see RemovePassowrd Select this Macro and give […]

Keep Reading

Microsoft Office 2010

Nov 30

When were finally getting used to the new interface on MS Office 2007, Microsoft have gone and launched Office 2010. You can download a beta version of microsoft office 2010 here Watch out for a full review of excel 2010 on this blog over the next week or so Remember Do My Books provide a […]

Keep Reading