astring
asked on
Formatting issues with Excel 2007 between workstations
I have an issue going on between 2 workstations involving formatting of a very complicated excel 2007 workbook.
Our Assistant Controller has put together a very detailed financial workbook that is color coded and formatted in a way to comply with our corporate financial department's specifications. This workbook is stored in a shared network folder. When the Controller opens the file for final inspection, it opens in 'compatibility mode' and there is no formatting.
Both machines are running MS Office 2007 and are both at the same patch level. Can someone point me in the direction of an answer?
Thanks
Our Assistant Controller has put together a very detailed financial workbook that is color coded and formatted in a way to comply with our corporate financial department's specifications. This workbook is stored in a shared network folder. When the Controller opens the file for final inspection, it opens in 'compatibility mode' and there is no formatting.
Both machines are running MS Office 2007 and are both at the same patch level. Can someone point me in the direction of an answer?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ThinkSpace hit the nail on the head actually. I just saw his reply. My apologies. It could either be saved on a 97-2003 format (.xls) or it was created on a higher Excel version (2010 for example) and it could be complaining.
The easiest way to fix that issue is to re-save it as an .xlsx
-Esteban
The easiest way to fix that issue is to re-save it as an .xlsx
-Esteban
ASKER
Darned accountants. Thanks for the refresher.
Have you tried putting a copy locally on the C: drive and see if the same issue happens? I was wondering in case this is a permissions issue on the network drive (unlikely) or a network issue period.
Let me do some digging while you look at that part.
-Esteban