• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Upgrading to Office 2013 - company wide, file conversions e.t.c.

We are currently performing audits in order to upgrade all current machines in the company from Office 2007 to the newer Office 2013 application.

All has gone with our audit except for one department which performs quite a bit of built in formulas e.t.c. in Office 2007 for sheet linking and so on.  We have found when upgrading a few of these users to Office 2013, that certain Office 2007 workbooks display errors in those formulas for some sheet linking e.t.c. if the actual sheet contains 'spaces' within them!!??

For those that have already upgraded to Office 2013, was there maybe an office conversion or test utility that you used to make problem spreadsheets and so on compatible to work within the new Office 2013 environment?

Thanks.
0
sparky321
Asked:
sparky321
2 Solutions
 
Zack BarresseCEOCommented:
Hi there,

It is not an issue when upgrading for spaces to be in worksheet names. There is something else going on. Were these possibly links to external workbooks, where the name was changed prior to the target file being opened/updated? Internal (workbook) references do not have this problem.

To specifically answer your question, no, there is no utility you can use to check for compatibility when upgrading. There are in fact very few issues whith forward compatibility, as Microsoft takes it very seriously. Do you have a reproducable workbook with this scenario? If so, can you post it? I have all versions to test with.

Regards,
Zack Barresse
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Sheet names containing spaces require them to be quoted when used in formulas. That isn't different for 2007, 2010 or 2013. So I agree there must be something else.
0
 
BlueComputeCommented:
There shouldn't be any difference, however this post on StackOverflow appears to show some differences in how spaces in sheet names are handled. Not sure that it relates to your issues but might be helpful.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
That discussion is about using the ADODB ACE (=Jet) driver, and something completely different.
0
 
BlueComputeCommented:
I certainly wasn't expecting points or it to be an answer. I appreciate it's a different situation however there's common factors discussed almost nowhere else.
Personally I think it's probably more useful than telling him the problem he's having doesn't exist but everyone has their own approach. Zack's right though; if it's reproducible with single example sheet seeing that would be most enlightening.
0
 
Rob HensonFinance AnalystCommented:
Are you able to identify any differences with the files that are causing errors?

One suggestion:
-Saved as 97-2003 format *.xls rather than 2007+ format *.xlsx

Can you also clarify what you mean by sheet linking? Link between sheets within a single workbooks (file) or links between sheets in different workbooks (files).

Thanks
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now