Solved

spreadsheet and google spreadsheet

Posted on 2014-02-13
3
305 Views
Last Modified: 2014-03-04
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
Comment
Question by:speedtofly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 96

Assisted Solution

by:Experienced Member
Experienced Member earned 250 total points
ID: 39858768
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
 
LVL 14

Accepted Solution

by:
Allen Falcon earned 250 total points
ID: 39858850
@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
 
LVL 96

Expert Comment

by:Experienced Member
ID: 39905129
@speedtofly - Thanks, and I was happy to help.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question