Hello,
I have been fighting with a few different spread sheets that contain lots of data. These are different vendor price lists that need to be combined into one list for importation into the company inventory. These spread sheets are again large and what I need to do with the lists after combining them makes them even larger. The best way I can figure to break it down to manageable sections is to filter the data to a portion that is more easily dealt with. I can consistently Crash Excel with the auto filters of excel when the list is very large. The actual crash happens when using the "contains text" search. My two experiments lead me to the conclusion that WE is the cause. I have saved another copy of my working spread sheets and had another computer user with office 2010 try to do the exact same filter criteria and the sheet does not crash for her. There are two differences with my machine and hers. She is running on a Windows 7 64 bit machine and NO Window Eyes. My machine is Windows 8.1 and WE 8.4.0. My second experiment was to unload WE and load Narrator, open the same spread sheet that crashes with WE and filtering and preform the same filter options. No crash occurs. I do feel like this is a problem with the way WE and Excel are talking to each other when there is a lot of entries that are to be conditionally filtered. I also notice that WE will have issue with Microsoft Query as well. I have a Word document that is connected mail merge to a data base. To include the items to be used on the merge document the MS Query is needed. Again this is a large data base. Even bigger than the excel sheets I am working with at this time. Often when clearing out the previous criteria in ms query the program will fail completely and I must either start completely over by closing all the programs and re starting the process of the mail merge. And that is not always the answer. It has many times required a complete reboot of the system to accomplish the mail merge. As a point of reference this mail merge is done frequently. This is how the work tickets are produced daily. This does cause limitations on use of the functions of the Office suite of products. In light of the new partnership between GW and Microsoft this simply should not be. These spread sheets don't have any proprietary information so If anyone wants to test out my theory I could share them. I have struggled with these for a while now and I had wanted to jump on the Office stinks band wagon, to the point I googled myself silly trying to find solutions to Excel Crashing for others. Answers were to disable all add ins, Done, Change default Printers to PDF printers, DONE and I still had the problem. There were no Ha-ha culprits listed for this problem. My simple switch to a different screen reader didn't exhibit this problem. So something is twisted up with my combination of WE, OFFICE and Windows. Anyone ever seen this behavior? Any ideas as to how the WE inter face can be made to handle more data than it is accustomed to? If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
