+ Reply to Thread
Results 1 to 3 of 3

Thread: Excel 2007 to 2003 Missing Formulas

  1. #1
    Valued Forum Contributor
    Join Date
    06-03-2008
    Posts
    349

    Excel 2007 to 2003 Missing Formulas

    I've been working on a tool that has some gigantic formulas in Excel 2007 but always saved in compatibility mode. I've always made sure there was no compatibility issues when saving. All the formulas appear to work in 2003, but it appears that I can't view one of my huge formulas in 2003. The formula appears to be working correctly, but it cuts off the end and puts some strange characters in. Anybody experience this same problem?

  2. #2
    Valued Forum Contributor
    Join Date
    06-03-2008
    Posts
    349
    After doing work in 2003, I just resaved the document and opened in 2007. All of my formulas are still in tact. There must just be a compatiblity issue where 2003 cannot display a formula past a certain length. This means you can't edit these type of formulas in 2003, but they do still work.

  3. #3
    Forum Guru VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    12,010
    Thanks for sharing your solution

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0