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

5,412 questions with no upvoted or accepted answers
6
votes
3answers
37k 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
1answer
308 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
0answers
51 views

Excel 2013/2016 not updating values while workbook is minimized

I have the following setup: 1 Workbook named Workbook1 with the value 123 in A1 1 Workbook named Workbook2 with value =[Workbook1.xlsx]Sheet1!$A$1 in A1 Now, when I go and change the value of ...
4
votes
1answer
68 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
355 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
2k views

Excel bug? Inconsistent behavior when Cut/Copy-Pasting across filtered data

Problem I'm seeing the following inconsistent behavior in Excel 2016, when Copying/Cutting/Deleting data across filtered data: Copying Cells: Data gets "copied" from the visible cells only, and not ...
4
votes
1answer
511 views

How to change the default 'fill-in' color in Excel for Mac?

When you're in Excel, you can fill a cell with a color (the icon is the paint bucket with yellow paint spilling out). I want to change that so the default color is green, not yellow as it always is. ...
4
votes
1answer
417 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
0answers
230 views

Excel- How do I find common text values from multiple (>2) rows?

This is essentially a variant of the question asked here: Excel- How do I find common text values from multiple (>2) columns? In this case, however, instead of multiple columns of data I need to ...
4
votes
1answer
801 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
866 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.

15 30 50 per page