Link to home
Start Free TrialLog in
Avatar of astring
astringFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That's odd.  If the machines are identical when it comes to Office (no extra plug-ins or a different version) and the patches for both Windows and Office are identical, this should work.

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
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
Avatar of astring

ASKER

Darned accountants.  Thanks for the refresher.