J
Jen
I started having this problem once in awhile and now it's
almost constant. When I attempt to add a formula, any
formula, to a data-filled spreadsheet, I end up with the
formula itselt in the cell instead of the results of the
formula. Yet, if I copy just the data I'm referencing, and
not the whole sheet, onto a blank sheet and re-create the
formula, I will (not always) get my results the first time
and can then copy and paste the results into my full
worksheet full of data. For instance, if I'm trying to use
=CONCATENATE on columns F & G in a full spreadsheet, I end
up with the =CONCATENATE formula, but if I copy only
columns F & G into a blank sheet and re-create the
=CONCATENATE formula, it will work just fine and I can
paste it into the full spreadsheet. HOWEVER, now the same
problem is starting to happen more and more often on the
blank sheet as well and I'm worried that soon I won't be
able to use formula's any more!
Since our IT guy here first tried saying that if I needed
formula help then I need a training class, not IT help,
then after several attempts on my part to explain this
over the phone his final answer was that our IT department
does not work with particular functions of any software,
that's not their job, then I guess I won't be receiving
any help here.
All of my large spreadsheets come from running reports
from Internet Explorer in our Niku system, and then
choosing the option to download the report in Excel
format. Could that possibly be linked to my formula
problem? Or does it not matter where the data comes from?
What could cause such a problem?
~Jen
almost constant. When I attempt to add a formula, any
formula, to a data-filled spreadsheet, I end up with the
formula itselt in the cell instead of the results of the
formula. Yet, if I copy just the data I'm referencing, and
not the whole sheet, onto a blank sheet and re-create the
formula, I will (not always) get my results the first time
and can then copy and paste the results into my full
worksheet full of data. For instance, if I'm trying to use
=CONCATENATE on columns F & G in a full spreadsheet, I end
up with the =CONCATENATE formula, but if I copy only
columns F & G into a blank sheet and re-create the
=CONCATENATE formula, it will work just fine and I can
paste it into the full spreadsheet. HOWEVER, now the same
problem is starting to happen more and more often on the
blank sheet as well and I'm worried that soon I won't be
able to use formula's any more!
Since our IT guy here first tried saying that if I needed
formula help then I need a training class, not IT help,
then after several attempts on my part to explain this
over the phone his final answer was that our IT department
does not work with particular functions of any software,
that's not their job, then I guess I won't be receiving
any help here.
All of my large spreadsheets come from running reports
from Internet Explorer in our Niku system, and then
choosing the option to download the report in Excel
format. Could that possibly be linked to my formula
problem? Or does it not matter where the data comes from?
What could cause such a problem?
~Jen