I am importing data from ten spreadsheets into oe consolidated one. Five
work, the data appears in the new spreadsheet and updates fine - in the
others some cells (the ones with the most important data) return blank,
refreshing the data makes no difference. Yet where blank cells are returned
the next column works fine.

Help- how do I fix this?

Thanks

Check to see if the data is in the column before the ones that are blank. I
would do a Colun Autofit to see all thje data in the worksheet. Select the
entire page by clicking the gray cell betwwh Column a and row 1. Go to
Format Menu - Column - Autofit Selection.

"enoakes" wrote:

I am importing data from ten spreadsheets into oe consolidated one. Five
work, the data appears in the new spreadsheet and updates fine - in the
others some cells (the ones with the most important data) return blank,
refreshing the data makes no difference. Yet where blank cells are returned
the next column works fine.

Help- how do I fix this?

Thanks