sparky321
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
That discussion is about using the ADODB ACE (=Jet) driver, and something completely different.
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.
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.
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
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