I just bought a new computer (Lenovo ThinkPad E560 with Solid State Drive and Intel Core i5 processor) with Windows 7 and the local version of Office 2016 (NOT Office 365). I have noticed when using Excel 2016 that there is sometimes a long delay when using the buttons in the top ribbon to paste values or to change the fill color of a cell. Oddly, the delay does not happen when I do a regular paste and then use the drop-down menu that appears in the file immediately after the paste to select paste values–it is only when I use the paste values command underneath the paste button in the top ribbon. The delay varies in length, but sometimes seems as long as 30 seconds or more. During this time, Excel essentially freezes up and I am unable to do anything with any open Excel window. The delay eventually clears, the operation (whether pasting or changing cell fill color) completes, and I am able to use Excel normally again. At first I thought it had to do with the number of cells being affected, but this has happened with large and small cell ranges alike, so I don't think that is the issue. The problem is intermittent. Has anyone else seen something like this? Do I need to reinstall Office?
Excel – How to fix a long delay in Excel 2016
delaymicrosoft excelmicrosoft-excel-2016microsoft-office
Related Solutions
Windows has a idle timeout for network drive connections; by default it's 15 minutes. So after 15 minutes of not using the share it will disconnect and the next time you go to use it you will have to wait for the connection to be made again (as well as any authentication processes that go along with it).
This really shouldn't take "minutes" to happen (maybe a couple seconds), but still this may be what you're running into.
You can see how long your idle timeout is set to by opening a command prompt and typing:
net config server
You can set the timeout limit (in minutes) as such:
net config server /autodisconnect:<#ofminutes>
You can turn off the idle timeout completely by entering:
net config server /autodisconnect:-1
See this MS KB article for more info.
Is there a general setting so that when a cell copy-paste is done only the content in the cell will be transmitted (with font and color) but not the cell borders ?
Paste special is not an option, the copy-pastes are done via keyboard shortcuts one.
Following my comment:
Yes: Paste, Special, No Borders; using the icons. If you use keyboard shortcuts, there is one called "all but borders". – ejbytes 19 hours ago
To take it a step further, just add it to your Personal Macro list. Why not? That's why it's there. Here we go:
Do you have a Developer's Tab? Not there? Enable it. Correct this by: File → Options, Customize Ribbon, Popular Commands → Main Tabs section → Select Developer checkbox.
Select Developer's tab:
Code Section:
- Click Record Macro.
- Give is a meaninful name like "pastespecialnoborders".
- Assign a meaningful Shortcut Key combo:Ctrl+Shift+V easy to remember right?
- Store Macro In: Personal Macro Workbook (this makes is work Excel wide).
- On current sheet: Copy a cell with borders on it → paste special → No Borders.
- Click Stop Macro.
- Press Alt + F11 → Modules → Module1 (double
click it to get inside of it). - Go back to your Module, the code, and modify it so it only has this
line:
Selection.PasteSpecial Paste:=xlPasteAllExceptBorders, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Test your new Macro Shorcut Key. Copy a cell with borders on it. Use your keyboard shortcut combo. Done.
You can also add this Macro-shortcut to your Ribbon or add it to your Quick Access Toolbar.
Best Answer
Change your default printer to a document printer (like XPS). Most inexplicable Office hangs are because Office insists on being in continuous communication with its printer.
You can also attempt the answers that were provided in the comments section--disabling hardware acceleration can help.