Burnabyryan said:
My office has .doc and .xls files if I upgrade everyone to the new software
am I going to run into any issues with my older documents? Are there any
issues with moving to the software with regards to opening and saving older
files?
....
Dunno about .doc files. For .xls files and Excel generally, there are
a few known issues.
1. Excel 2007 won't save VBA modules in .xls[mb] files if those VBA
modules contain only options, compiler directives or global
declarations but no Sub or Function procedures. While it's unlikely
that you have VBA modules without procedures, this could fubar macro-
driven .xls models.
2. Excel 2007 no longer supports labels (aka natural language
formulas). Excel 2007 will replace labels with the ranges to which the
labels refer when opening .xls files that use labels.
3. Recently reported, Excel 2007 can fubar formulas containing
external references to ranges in other workbooks in certain
circumstances. For example, Excel 2003 supports formulas like
='c:\foo\[myfile.xls]SheetX'!$C$3-'d:\bar\[myfile.xls]SheetX'!$C$3
and when you open one or the other of these files (no version of Excel
will let you open both at the same time because Excel is unique among
Windows (and perhaps among all GUI apps under any OS) in being unable
to handle multiple open files with the same base filename), the
reference to the other file will remain intact. In Excel 2007, OTOH,
if you open either file, the formula above becomes
=[myfile.xls]SheetX!$C$3-[myfile.xls]SheetX!$C$3
That is, Excel 2007 screws up one of the external references so that
both point to the open file. If you then save the file containing this
formula, the external references are saved in this fubarred state.
If your .xls files are simple, you may not have any problems. No
guarantees though.
