Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

spreadsheet and google spreadsheet

Posted on 2014-02-13
3
Medium Priority
?
319 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
  • 2
3 Comments
 
LVL 99

Assisted Solution

by:John Hurst
John Hurst earned 1000 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 15

Accepted Solution

by:
Allen Falcon earned 1000 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 99

Expert Comment

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
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 shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

886 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