I'm wondering if there would be a difference to a file size if instead of having 200 worksheets, which I currently have, I have all the info from those 200 worksheets in one worksheet (which would mean there are thousands of rows). My current file is 87 Meg and this is unworkable for my environment. If there would be a reduction in size by putting it all on one worksheet, does anyone have any rough idea of how much it might cut down the file size by?
Many thanks,
Many thanks,