Thanks BanginMyHeadOnMyDesk, I do have data that i can't desensitize and the file size of my workbook is way to large to attempt uploading anyway....The thing i worry about with "hiding" the data in rows is the other sheets have alot of cells referencing the ones we might apply a "hide" function to but if the data is still inside the cells of row 5 wouldn't the cells on other sheets still see them and continue referencing them? Make sense?