Help!

When i open my shared workbook, one of my tabs with all the data contained
within is gray, you cannot see anything.

When i run a macro that uses that sheet the data is there, however the
headings are missing.