I have a couple of excel files which i link to via an Access database. I use a union query in the database to view all the sheets together. but ive noticed that two of the spreadsheets are increasing in size at an alarming rate, one has jumped to 15mb and the other has jumped to 25mb. dispite fixing the file sizes by creating new spreadsheets for the duff files, This keeps happening, but only to these two files. Has anyone else experienced this problem and is there a fix for it?
"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks
"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks