M
mapnet
I've searched around trying to figure out how to solve this issue, bu
the problem is I don't know what exactly to call it. I've trie
everything I can think of to fix and I'm still stuck - Short of retypin
all the data, which I did for a few small sheets.
Using 2007. Formulas only work when I click on the cell and hit ente
again. If its a simple sum function and I add 10 to one of the cells
it doesn't add automatically. Same thing for -,/,* and more comple
formulas. This only happens in old files/sheets that are i
Compatibility Mode (read background below).
Background:
I had 2003 and had a buddy backup all the files from my PC (excel, pics
docs, etc) on an offline server I keep offsite. In the process h
loaded office 2010 on my PC, but it turns out it wasn't a copy I coul
use long term as I needed to be connected to his corporate network fo
the registration to finalize. Once I discovered the 2010 issue,
couldn't go to him because he's now over in Afghanistan serving, so
loaded 2007 (i have a dozen or so licenses of 2007 unused).
I'm not sure if its an issue with 2003 converted to 2007, or if its th
2010 converted back to 2007, or 2003 converted to 2010 converted t
2007.
Thank you in advance for your help
the problem is I don't know what exactly to call it. I've trie
everything I can think of to fix and I'm still stuck - Short of retypin
all the data, which I did for a few small sheets.
Using 2007. Formulas only work when I click on the cell and hit ente
again. If its a simple sum function and I add 10 to one of the cells
it doesn't add automatically. Same thing for -,/,* and more comple
formulas. This only happens in old files/sheets that are i
Compatibility Mode (read background below).
Background:
I had 2003 and had a buddy backup all the files from my PC (excel, pics
docs, etc) on an offline server I keep offsite. In the process h
loaded office 2010 on my PC, but it turns out it wasn't a copy I coul
use long term as I needed to be connected to his corporate network fo
the registration to finalize. Once I discovered the 2010 issue,
couldn't go to him because he's now over in Afghanistan serving, so
loaded 2007 (i have a dozen or so licenses of 2007 unused).
I'm not sure if its an issue with 2003 converted to 2007, or if its th
2010 converted back to 2007, or 2003 converted to 2010 converted t
2007.
Thank you in advance for your help