First issue that I noticed is that excel was taking a long time to load/save/formula calcs. Then shortly after I was getting errors that I had too many formats in my workbook. I think removed almost all formatting in the sheets and made it all universal. There are about 15 tabs and most sheets don't go past 50/z. A few go to 500 or so. I also use this file on a daily basis. So it is constantly being opened and closed.
I then noticed that I could not copy and past between workbooks. I would copy the information and when I pasted it, the area where it should be is outlined, but no information is there. No, its not a formatting issue, the info is just not there. I then noticed that I could copy and paste 1 time and after that it would not work. Also, it still allows me to copy and paste within the same workbook.
I then noticed that Excel was saving the file to a much larger size then it should be. It didn't matter if the file had 1 row or 1000 rows, the size is around 300kb.
Please help and give suggestions. These issues are keeping me from completing my job functions and my IT dept claims I am doing something wrong for these issues to be happening. Some steps they used to fix...
Clear cache. Run fix Office. reimaged my machine. updated bios.
Thanks for any help you can give me....