I have 2 excel files. One links to the other. It is a payable spreadsheet. Sometimes I have 1 item listed on file one, sometimes it's more than 3. I did a copy and paste special link from file 1 to file 2. The thing is than when I only have 1 item on file 1, file two will show a "0" when I don't have any data on file 1 to link to file 2. How can I eliminata the "0" from showing when I have no data on file one? Hope I made sense.