Solved

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

Posted on 2014-04-23
8
133 Views
Last Modified: 2014-08-08
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
Comment
Question by:sparky321
8 Comments
 
LVL 14

Assisted Solution

by:Zack Barresse
Zack Barresse earned 250 total points
ID: 40019188
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
 
LVL 68

Accepted Solution

by:
Qlemo earned 250 total points
ID: 40019403
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
 
LVL 14

Expert Comment

by:BlueCompute
ID: 40019525
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 68

Expert Comment

by:Qlemo
ID: 40019659
That discussion is about using the ADODB ACE (=Jet) driver, and something completely different.
0
 
LVL 14

Expert Comment

by:BlueCompute
ID: 40020086
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
 
LVL 32

Expert Comment

by:Rob Henson
ID: 40020642
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel conversion issue with Sql server 14 46
time format showing wrong 12 49
Sum iF  based on a null cell 11 29
Pivot help - Display only Is Not Null 7 12
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now