Software

Ask something
Question Locked

Converting from Excel 2003 to Excel 2007

0 helpful
2 replies

by brifd1 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a complicated, multi-tabbed financial model that uses a variety of functions. In version 2003, no problem. The conversion to 2007: calculations = 0. The first problem: =SUMIF(Exp_ID_Lookup,CONCATENATE(A6,A11),Expense_Lookup)
Both named ranges are correct. I did an Evaluate Formula, and the CONCATENATE does the correct appending, but still 0 is the result.
I had a problem with another spreadsheet where I had to change a permission to open the floodgates, but that was a couple of weeks ago, and I don't remember where it was (or if it even applies here...if so, I'd better write it down, although one would think that a global option would be available!). Could this be the solution?
Thank you for your help! This, unfortunately, is part of a time-critical project.

2 replies

by brifd1

It's been awhile since I've been in technical support (~ 15 years), but I hadn't tried one of my other standard solutions. I re-created the sheet that was the source of where the data was being looked up (within the workbook itself), changed the references to it, and voila, everything's hunky-dory again.

This discussion is closed to new replies.