how do I link 2 spreadsheets and have the second one autosort ign.
 

I am trying to link 2 spreadsheets in a workbook and have the second one
automatically sort when changes are made to the first. Is this possible?

Also, I tried linking the spreadsheets and sorting manually, but the second
spreadsheet is pulling in the first document's blank cells as zeroes and
sorting them at the top of the document. I tried formatting the cells as text
and hiding zeroes but the blank cells are still sorting at the top. How do I
fix this?