Excel is very slow to load files

i had a file with 10,500 lines, 18,000 kb and it seemed slow to load (about a minute) every time i made changes and then saved it or reopened it.

so i broke the file up into 3 smaller files by cutting and pasting. i deleted all empty lines and columns beyond the file content. i defragged my compter. i cleared all excess format in job history - but -

one file now has 3,900 lines, 22,300 kb and takes 4 minutes to load.

one file now has 2,000 lines, 20,100 kb and takes 4 minutes to load.

one file now has 4,900 lines, 14,500 kb and takes 1 minute to load.


what is wrong?

thanks for the suggestions.

i am trying to attach a few lines from the first part of my excel file.

however, i am also having trouble attaching the file to my message - i get an error message saying a 'security token' is missing.

maybe there are formatting issues making the files so big- try the below add-in....

http://www.microsoft.com/downloads/d...displaylang=en

i downloaded the file to my MS Office file, unzipped it, then tried to open it but got a message - 'file is already open' and could not figure out how to use it. sorry, i feel like an idiot.

i eliminated all links - no change in file size or download time.
i eliminated all programs - "
i cut the size of my file way down to 4 columns & 12 lines - "

i copied the much reduced file to a new clean excel page - the size & download time was reduced, but the pasted copy acts like a photo, does not respond to modification by excel.

i imported the original 20,000 kb 4 min download file to a clean file - it was reduced to a 500 kb fast download file - but the imported links and programs do not work. i can live with redoing the programs - but redoing all the links would be weeks of work.

i tried copying the links from the original file and pasting it into the new imported copy but again it acts like a photo which does not respond to manipulation by excel.

i eliminated all 'worksheet functions' and 'hyperlinks'

i reduced the file to 3 columns and 14 rows

it still is 19,000 kb in size and takes 4-5 minutes to load

i still cannot attach it to this reply

i will try to zip it and attach it to my next reply

now i will try to attach the zipped file to this reply

not sure if zipped attachment is loaded - am trying again with this reply

how does one tell if attachment is loaded or not?

i have imported my original file to a new clean worksheet and now am pasting the hyperlinks into the new worksheet.

the new worksheet seems to work just fine.

i guess the original file somehow became corrupted and there seem to be no way i could fix it.

thank you to everyone who thought about and/or responded to this problem.

reading your responses did stimulate me to think and continue to work for a solution.