• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

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?

  • 2
1 Solution
Steven HarrisPresidentCommented:
Is the document saved in 97-2003 format?

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now