Data from Connections

[stvbrown2184]

I have data coming in from an existing connection onto a new spreadsheet. But not all the data shows up from the connection. cells with a number only or text only come through. However if a cell has both numbers and text the cell will not show up on the existing connection worksheet.... any ideas what the problem may be?

1234... shows up on connected worksheet
1234A... will not show up

[oeldere]

will not show up means:

you get a blanc cell.

you get a failure in the cell.

you get something else?


is 1234A in the orignal list (so it has to be found?)

You have leading or trailing spaces in one of the values; in that case the values are not equal (if you are using VLookup or match).

[stvbrown2184]

oeldere: will not show up means I get a blank cell.

1234A is just an example... any data with both numbers and text is just an empty cell

[oeldere]

and what formula do you use?



You get better result on your question if you add a small excel file, without confidential information.

Please also add the expected results manualy in your file.

[stvbrown2184]

ss.png


i attached a screen shot of the problem. the blue/white workbook is the linked file.

[oeldere]

I can't read PNG files. so I asked for:

add a small excel file

Other forummembers mostly don't want to recreate your file (PNG) just to help you.

[stvbrown2184]

ok see attached for worksheet. sheet 1 is my data, sheet 2 is the result of the linked file.

[oeldere]

see if these index/match formula's meets you expectations.

[stvbrown2184]

I appreciate your effort, and I am familiar with index/match, but the linked files will be used for other employees to a link to my workbook. I am trying to create a situation where all they have to do is hit refresh all and they will see all the changes to the inventory. The index/match will not show new data unless they manually drag the formula down which I dont think is a reliable option. The fiel I attached was just a snapshot of the entire workbook, our real workbook contains 35,000+ line items and grows daily.

[oeldere]

then make a table of your data

excel 2013 => Insert => Table.

if you add a formula IN the table, the formula will automatic expand to the last row of that table.

[stvbrown2184]

Its strange because other workbooks I have linked data to will pick up alphanumeric data but this workbook only picks up numeric only or text only

[stvbrown2184]

keep getting error that table data has to be on the worksheet... so a table cannot be created.

[oeldere]

excel 2013 => Insert => Table.

show the failure on this forum.