D
Derrick
I just wanted to put this out her, because I have been have this
problem for weeks, and could never find an answer to the problem out
here.
I receive spreadsheets (certain template) from many different people
on a daily basis. When I do, I run a few VBA functions on the sheets
in order to get the information into Access. I had this problem for a
couple of people that the new sheet was not recognizing the data as
anything at all. I have two tabs, one tab would have the data and you
could see it, and the other tab was filled with references to that
data in the format I needed it.
The second tab would be empty, but the first had data, so it was like
the data was not there at all.
After many weeks of poking around and testing, I finally found an
answer. On the spreadsheet I was receiving that was not working, the
Excel Automatic calculation was switched to manual. This means, that
the field was not being recognized as valid because the newly pasted
data had not been 'manually calculated'.
So, if you are having problems like this. Make sure that Automatic
Calculation is turned on. Tools>Options>Calculation>automatic
calculation. I just built the change into my VBA, so i do not have to
do it manually.
I hope this helps someone out there.
problem for weeks, and could never find an answer to the problem out
here.
I receive spreadsheets (certain template) from many different people
on a daily basis. When I do, I run a few VBA functions on the sheets
in order to get the information into Access. I had this problem for a
couple of people that the new sheet was not recognizing the data as
anything at all. I have two tabs, one tab would have the data and you
could see it, and the other tab was filled with references to that
data in the format I needed it.
The second tab would be empty, but the first had data, so it was like
the data was not there at all.
After many weeks of poking around and testing, I finally found an
answer. On the spreadsheet I was receiving that was not working, the
Excel Automatic calculation was switched to manual. This means, that
the field was not being recognized as valid because the newly pasted
data had not been 'manually calculated'.
So, if you are having problems like this. Make sure that Automatic
Calculation is turned on. Tools>Options>Calculation>automatic
calculation. I just built the change into my VBA, so i do not have to
do it manually.
I hope this helps someone out there.