Stack Exchange Network

Stack Exchange network consists of 175 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,946 questions with no upvoted or accepted answers
6
votes
3answers
40k 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
2answers
134 views

Microsoft Office Tools- permanently remove author name

I am having some trouble with Microsoft Office tools, I want to permanently remove the author name from all future created documents. Word, Excel, etc, keep pulling my computer login username (Lets ...
5
votes
1answer
471 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 ...
5
votes
1answer
22k views

How can I create a “Cross-Join” in excel?

I have 2 sheets in excel, each with 10 rows. Is there some sort of "cross-join" formula/macro in Excel that allows me to create a 3rd sheet with all rows cross-joined (100 rows in total).
4
votes
1answer
77 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
119 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
464 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
3k 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
752 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
561 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
314 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
884 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
2k 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
7k 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 ...

15 30 50 per page