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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
Is the document saved in 97-2003 format?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Esteban BlancoPresidentCommented:
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 BlancoPresidentCommented:
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

astringAuthor Commented:
Darned accountants.  Thanks for the refresher.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.