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?
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.
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 !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks