• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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!
0
speedtofly
Asked:
speedtofly
  • 2
2 Solutions
 
John HurstBusiness 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
 
Allen FalconCEO & 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
 
John HurstBusiness Consultant (Owner)Commented:
@speedtofly - Thanks, and I was happy to help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now