Repairing and updating old spreadsheets

Resolved · Medium Priority · Version 2007

Tue 25 Oct 2016, 16:58 Delegate Robert said...

Robert has attended:
Excel Intermediate course

Repairing and updating old spreadsheets

I use an older version of excel and would welcome some help to repair, clean up and upgrade to a new more current version.

Wed 26 Oct 2016, 10:50 Trainer Jens said...

RE: repairing and updating old spreadsheets

Hi Robert,

Thank you for the forum question.

Normally you shouldn't have any problems open old spreadsheets in a new version of Excel, but if you have links and references in the spreadsheets you can get errors.

If you click Name Manager on the Formulas tab in the Defined Names group, you will get a list of broken references (if this is the problem). Delete all broken references.

Also check if you have any broken links. Go to the DATA tab and click Edit Links in the Connection group. If Edit Links is greyed out then you have no links and you have no problems with links.

Let me know if you need more help.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 2 Nov 2016: Automatically marked as resolved.

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips

Repairing and updating old spreadsheets

Repairing and updating old spreadsheets

RE: repairing and updating old spreadsheets

Excel articles

Excel tip:

Adding multiple rows in an Excel 2010 Worksheet