Try turning calculation to manual, THEN open the workbook. If you see
numbers, copy/paste special values, and you're all set.
HTH
Bob Umlas
Excel MVP

"LunaMoon" wrote:

Hi all,

I need your help.

I have an Excel sheet, where we used a 3rd party API and called a
function. So each cell has a function call to retrieve some data from
some database. We have successfully collected data from the database.
And we now no longer have access to the computer which is equipped
with the API and database, due to expiration of trial period.

And after we collected data, and back at home, we opened the Excel
sheet on a computer that does not have API installed and does not have
access to the database, only to find "#NAME?" displayed in all the
cells.

Basically, because the 3rd command/function cannot be run on this
computer, all the collected data are now gone, and we only see
"#NAME?" error message.

This is super inconvenient and we should have copied and pasted the
collected numbers as "numbers" into a separate Excel sheet. Due to
inexperience of using Excel, we forgot to do that. And we don't have
access to the 3rd party command/API as well as the database any more,
due to expiration of trial period.

Any remedies? Please give us help! Thanks a lot for your help! Really
appreciate it.