G
George
I USE AN EXCEL SPREADSHEET WITH MACROS THAT ERASE LINES
AND SORT CERTAIN DATA. OVER A PERIOD OF ABOUT A WEEK THE
FILE BECOMES LARGE AND HARD TO OPEN. AT THE END OF EACH
DAY ALL DATA ENTERED IS ERASED USING THE "CLEAR CONTENTS"
BUT THE FILE CONTINUES TO GROW. I OFTER ADD OR DELETE
LINES FROM THE SPREADSHEET AS EXTRA LINES ARE NEEDED OR
NOT. COULD THIS BE CAUSING THE PROBLEM?
THANKS,
GEORGE
AND SORT CERTAIN DATA. OVER A PERIOD OF ABOUT A WEEK THE
FILE BECOMES LARGE AND HARD TO OPEN. AT THE END OF EACH
DAY ALL DATA ENTERED IS ERASED USING THE "CLEAR CONTENTS"
BUT THE FILE CONTINUES TO GROW. I OFTER ADD OR DELETE
LINES FROM THE SPREADSHEET AS EXTRA LINES ARE NEEDED OR
NOT. COULD THIS BE CAUSING THE PROBLEM?
THANKS,
GEORGE