We recently replaced all our desktops with brand new decent spec'd Win7 with office 2013, and I have to say excel 2013 is a nightmare.
Users continually run into issues, what they're doing is finding web content online, copying it from a browser and pasting it into excel, and ending up with workbooks that are full of web content.
Excel when copy/pasting this between worksheets or different files has to parse the web content and it can take i5's with 4Gb of RAM a good 1-2 minutes to parse even a small amount of web content, it's completely ridiculous. There's also instances where excel will appear to have closed after using one of these files but the exe is still running and trying to open other files results in excel throwing errors, like out of resources (which it's not), until you end the previous process.
Is there any way as an admin I can enforce some kind of group policy or force excel to accept text only under all circumstances, there has to be some way to control this as trying to teach users about pasting as text only or to paste into a txt file first to remove formatting isn't working, they don't get it.
Thanks to anyone who can help.
Users continually run into issues, what they're doing is finding web content online, copying it from a browser and pasting it into excel, and ending up with workbooks that are full of web content.
Excel when copy/pasting this between worksheets or different files has to parse the web content and it can take i5's with 4Gb of RAM a good 1-2 minutes to parse even a small amount of web content, it's completely ridiculous. There's also instances where excel will appear to have closed after using one of these files but the exe is still running and trying to open other files results in excel throwing errors, like out of resources (which it's not), until you end the previous process.
Is there any way as an admin I can enforce some kind of group policy or force excel to accept text only under all circumstances, there has to be some way to control this as trying to teach users about pasting as text only or to paste into a txt file first to remove formatting isn't working, they don't get it.
Thanks to anyone who can help.