Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Unanswered Questions

12
votes
2answers
8k views

How to disable snap/jump scrolling in Excel 2016 for Mac

I'm desparately looking for a way to disable snap-scrolling in Excel 2016 for Mac. Basically as you scroll Excel will continually try to keep the cell you're focused on in the centered. So when you're ...
6
votes
3answers
35k views

Can't exit design mode because Control 'xxxx' can not be created

What is the cause of this error and how do I fix it? This started occurring on a workbook of ours for reasons unexplained. I made a tiny change to the VBA code behind it, just plotting slightly ...
5
votes
0answers
197 views

Create PDF from an Excel file without margins in Windows 7

This question is kind of answered, but that solution doesn't work for Windows 7. I've set margins to 0, no scaling and put colored shape all over printable area (few columns and rows from A1), for ...
4
votes
1answer
48 views

MS Excel: Displaying custom lower error bars

I have an odd issue with custom error bars in MS Excel 2016 (from MS Office 365). The upper error bars are showing but not the lower ones. At least not all the time... only once in a while... See the ...
4
votes
1answer
196 views

Respond to SharePoint Survey through VBA

How can I respond to SharePoint surveys through VBA? I am trying to track a workbook's usage through a macro but I can't seem to figure it out or even the proper search terms to to search. Any ...
4
votes
1answer
379 views

Is there a way to automatically download files from Gmail or Google Drive

Disclaimer: Ouside of a little VBA knowledge I am not a programmer. I have several Web-Intelligence reports that are scheduled to automatically run for my company. Ideally, we would have the reports ...
4
votes
1answer
728 views

Make dropdown list show hyperlinks

I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them ...
4
votes
1answer
1k views

Function names in international versions of Excel

I'm writing a documentation how to use some Excel functions in a rather company specific context for novice users. I noticed that the functions seem to have completely different names in non-English ...
4
votes
1answer
1k views

Excel VBA : SQL query handles error

I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...
4
votes
1answer
6k views

How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you... First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...
4
votes
0answers
3k views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
4
votes
1answer
856 views

Create line graph with embedded horizontal histogram

How do I create these kinds of graphs: with the horizontal histogram counting the number of times the left graphs go through a certain range? I have access to Microsoft Excel and R.
4
votes
1answer
2k views

Key command for move cursor to next different value in column in Excel

Some Excel jockey told me how to do this once, but I've forgotten. Basically I have a huge list sorted by a STATUS column. I'd like to press the down key and go to the next changed value in the ...
4
votes
1answer
5k views

Excel 2016 Freezing when entering data into a spreadsheet with multiple formulas

When working in spreadsheets with multiple formulas, if users enter data into a cell then leave the cell, Excel freezes for a few seconds to a couple minutes. The time varies depending on which ...
3
votes
1answer
86 views

Missing Paste (P) option in Excel 2016

I'm copying some data from a webpage which is tabulated. When I click CTRL + C in Excel 2010 and CTRL + V to paste, it pastes correctly. However in Excel 2016, the Paste (P) option is not there. ...

15 30 50 per page