spreadsheet and google spreadsheet

I try to upload a Xlsx doc but on columns shows those #REF!  instead of the SKU numbers.
How can I fix that
(It shows like that in google spredasheet, microsoft office suite , but I see the SKU number on my tablet in the app office)

80010035L
80010060
#REF!
#REF!
80010016
#REF!
#REF!
#REF!
#REF!
#REF!
speedtoflyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Allen FalconConnect With a Mentor CEO & Pragmatic EvangelistCommented:
@John Hunt is correct.  

In the original xlsx file, copy the column and paste as values to remove the external links, or get the source data online as well.
0
 
JohnConnect With a Mentor Business Consultant (Owner)Commented:
The SKU numbers must have a source from a file that was not uploaded with the main spreadsheet. That is how the cells lost the reference.

Can the sheet with the data be included with the main spreadsheet so the references are all internal?
0
 
JohnBusiness Consultant (Owner)Commented:
@speedtofly - Thanks, and I was happy to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.