Questions tagged [microsoft-excel]
A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function. Also add the the specific version tag (e.g. [microsoft-excel-2019] or [microsoft-excel-365]) as features and functions may vary between them.
8,888
questions with no upvoted or accepted answers
3
votes
0
answers
129
views
Excel (Mac) updates, disable banner
Is there a way to disable for ever and ever and ever this annoying banner?
I tried to remove the update service, I tried to set the updates to manual, I had it check for updates so that it could ...
3
votes
1
answer
750
views
Define Name for Worksheet Scope in Microsoft Excel for Mac V15.38
I am trying to create named references that have a Worksheet scope in Microsoft Excel for Mac V15.38.
I want to set up a template sheet that gets duplicated multiple times (example: a template sheet ...
3
votes
1
answer
412
views
How to use Excel to get a Function Equation from a trendline?
I am struggling with Excel right now. What I have is a graph which can be approximated by a polynominal formula. I have values for X and Y Axis and want to get the equation of the trendline. To stay ...
3
votes
0
answers
280
views
Weird watermark when pasting Excel graph as picture with gridlines
When I paste an Excel 2016 graph as an image in Word (also 2016), if the graph has gridlines, the image displays some kind of watermark in the center, like this: .
I know the problem are the ...
3
votes
0
answers
1k
views
What are the security risks to enabling editing in Excel and Word, if macros are disabled?
I'm using Office Professional Plus 2016. I often receive Excel spreadsheets and Word docs from clients and need to make small changes before sending them back. Assuming that my macro settings are set ...
3
votes
3
answers
3k
views
Keeping locked cells when copying a worksheet
How do I copy an Excel worksheet, with protected cells, onto a new sheet and retain the locked cells? I have tried the normal protection sequences but every time I copy the sheet, the new sheet has ...
3
votes
1
answer
3k
views
Can I automatically sort a grouped and stacked pivot chart by a sum of values without showing this on the chart?
I am working with data in groups in Excel. I currently have a pivot table and chart set up with:
Rows: symptom name grouped into one of four international severity grades
Columns: four datasets - ...
3
votes
3
answers
170
views
Excel data in rows and columns to be reformatted
I have data in Excel in a staggered format. There is a customer ID in the left-most column and the details of that customer are in different rows within different columns. I need to rearrange the ...
3
votes
1
answer
218
views
Excel is closed, but using a lot of resources
Versions:
Office Home and Business 2016 (last updated 1/?/17)
Windows 10 (last updated 4/5/17)
Issue:
For the past few days... possibly since the last Windows 10 update (two days ago)... my fan ...
3
votes
2
answers
1k
views
How do I reorder sheets in specific order, then alphabetically?
I need to reorder my sheets in a specific order, then if there are any left, do it alphabetically. I have the macro below to reorder them alphabetically.
If i have sheets ""METALS", "SVOC", "GENCHEM"...
3
votes
1
answer
2k
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. ...
3
votes
1
answer
107
views
Timeout error itgenerr024 when trying to import data from Exact Online into Microsoft Excel with Invantive Control
When I execute the query I get the following error after ten minutes:
Error processing file 'c:\temp\in\GLTransactions\070-GLTransactions-2016-9-4-102.xml':Invantive.Data.OAuthException: itgenerr024: ...
3
votes
1
answer
1k
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 ...
3
votes
0
answers
571
views
When customizing the Ribbon in Excel 2016 on Windows, what governs Group layout within a Tab?
Is it possible for the layout and format of Command items in an Excel Ribbon Group to be controlled by the user (i.e. through "normal" use of Excel, without recourse to XML hacking or UI editors)? ...
3
votes
0
answers
2k
views
Imported XML occupying multiple rows?
I want to import an XML file into an Excel sheet in order to perform operations.
When I import the XML file I get the following structure:
As you can see, all variables are on different lines.
Here ...
3
votes
0
answers
977
views
How to force Excel to use English formats on non-English locale?
I'm using English Windows, English Office but my system locale is Czech. This unfortunately leaks into Excel:
How do I get rid of this? I want my worksheet to be pure English (US) – all amounts in ...
3
votes
1
answer
2k
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 ...
3
votes
1
answer
699
views
Editing a "Fixed Width" Text File
I had originally drafted this question in Engineering SE, but on second thought it makes a lot more sense here. I don't know if SuperUser SE just doesn't have MathJax formatting or if I don't know how ...
3
votes
1
answer
1k
views
Optimize row height/column width in Excel = minimize white space
I often create tables in Excel where some cells contain a lot of text while others just contain a single digit or some other short value. With wrap text in cells enabled and then a combination of ...
3
votes
1
answer
2k
views
Cells evaluated by user-defined module do not update automatically
I read the questions existing but no answer seemed to help. I have a function I wrote in VB which evaluates sum of cells in a certain range by font color, it all works well when I type the function in ...
3
votes
1
answer
4k
views
How to disable “marching ants” from overriding my external clipboard data in Excel 2016?
Did the copy-and-paste behavior change in Excel 2016?
Every time I want to copy something from an external application, I have to press Esc first in Excel 2016 to cancel the marching ants (selection ...
3
votes
1
answer
184
views
Checkbox location changes when workbook is opened in Excel 2010
I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell.
When I open it at work with Excel 2010, all the ...
3
votes
2
answers
87
views
VBA - reformatting a 3 column into 9
My data looks something like this, very very long vertically.
#1, name1, number1
#2, name2, number2
#3, name3, number3
...
#2000, name2000, number2000
I want to reformat into 2 or 3 sets of column ...
3
votes
1
answer
782
views
Sum values in specific rows based on whether the row has a value that belongs to a range
Here's what I'm trying to do:
I have a table that has several metrics (example: revenue, cost, etc.) for about a hundred different accounts. I can't modify this sheet because it gets auto-updated by a ...
3
votes
1
answer
144
views
Varying Format Part Number Sort Issue
(Current Sort Sample:)
2-1203-4
2-1206-3
2CM-
3-1610-1
3-999
…
AR3021-A-7802
AR3021-A-7802-1
B43570-
B43570-3
I am working on an 8000+ record parts list. The challenge I am running into is that ...
3
votes
2
answers
333
views
Excel 2013 VBA programming
I'll start off my saying I'm trying to save time for a family member who is doing this program manually.
Sheet 1
Column A is a start date
Column B is a projected start date
Column E is a Task Name.
...
3
votes
1
answer
666
views
Why does Excel Table Format, always use absolute referencing in formulas. Any way to disable it?
The Table format (Home> Format As Table) option is a good feature of Excel. I am using it in Excel 2013.
But when I put a formula and try to copy it across, it does not work. Trouble comes when you ...
3
votes
2
answers
10k
views
Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh
I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post.
The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...
3
votes
2
answers
6k
views
Excel formula to populate from one column only if another is empty?
I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not ...
3
votes
2
answers
10k
views
Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to ...
3
votes
1
answer
475
views
Expanding a cell formula resolving all its references (precedents)
In Excel I have a cell containing a formula referencing other cells, which reference other cells and so on... forming a large tree of references. I'd like to substitute recursively all the occurrences ...
3
votes
1
answer
2k
views
Data Validation arrow hidden from freeze panes?
I've been searching with no luck about my issue of the data validation drop-down arrow being hidden by freeze panes.
I have read multiple forum posts about Excel 97 having this as a bug, but fixed in ...
3
votes
1
answer
2k
views
Excel VBA not working when "enable editing"
I'm not sure if this is the right place to post this but I'm having issues with excel VBA. I sent a worksheet with custom VBA attached to an email. Once the user downloads the file, it open in excel ...
3
votes
3
answers
19k
views
Hyperlinks to web pages in my Excel workbook don't work now
Hyperlinks to web pages, saved in my Excel workbook don't work after upgrade to Windows 7 and new hard drive. Have had this spreadsheet for years. I was always able to click on the link and it ...
3
votes
1
answer
6k
views
Setting direction to right to left on Excel 2011 on Mac
I am using Excel 2011 on a Mac and would like my Excel worksheets to be right to left.
I am trying for a long time already and can't find a solution.
How can I do it?
3
votes
2
answers
10k
views
How do I find which Pivot Tables has an error in Excel 2010?
I'm receiving an error:
cannot open PivotTable source file ...XLSX SHEET...
while refreshing all data. I have many Pivot Tables, and I can't find that one with the error, while refreshing ...
3
votes
1
answer
3k
views
Calculation takes forever in large data set on Excel
I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
3
votes
1
answer
1k
views
excel vba: to export multiple excel sheet into its designated jpg file
I am working on an excel vba command to export multiple excel sheet to its designated jpg file.
I have 16 worksheet in one excel workbook and it would be best to export each sheet into jpg format.
...
3
votes
3
answers
4k
views
Mail Merge function in Word 2010
I have this Excel file that has multiple sheets that I wish to import to Microsoft Word's letter format.
Firstly I started mail merge to this excel file and selected this particular sheet/table, then ...
3
votes
1
answer
959
views
Find 5 second peak value in Excel
How do I find the peak value within a 5, 10 or 15 second time period if I have a range of data like the one below? In other words, which 5, 10 or 15 second period has the highest utilization and what ...
3
votes
2
answers
16k
views
Can I link images using a relative path?
I am working on an MS Excel workbook that contains around 200 images. They are currently saved within the workbook, so the file becomes huge and working gets very slow.
Linking the pictures without ...
3
votes
1
answer
773
views
How to automate transforming a table into a matrix
I've been looking for a way to automate transforming data in an Excel table into a matrix.
For example, from the left table into the matrix on the right, as shown in the following image:
Apparently ...
3
votes
3
answers
2k
views
Counting frequency of comma-delimited tags in Excel
I have an excel spreadsheet with a list of seminars and classes that students have taken that (when abridged) looks like:
(A)___ClassName________|(B)_________Tags____________|
Astrobiology |...
3
votes
0
answers
3k
views
Excel/Word on MAC - includepicture containing url
I have the following:
A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code.
A word doc where these names and ...
3
votes
2
answers
192
views
Is it possible to edit the source representation of objects in Excel?
I often find myself copying and pasting worksheets in order to show the same analysis for different sets of data. This includes graphs. It's irritating having to 'select data' for every data series, ...
3
votes
1
answer
3k
views
Embed Excel spreadsheet inside PDF
Is it possible to embed an Excel spreadsheet in a PDF file that updates automatically whenever you open the PDF (like Word does)? I want to show the spreadsheet contents (with updates) in the PDF. I ...
3
votes
1
answer
3k
views
Excel 2010 shows different cell fill colors depending on Windows Appearance Settings
I just noticed something very strange. I created an Excel workbook in Excel 2010 (Windows 7) and manually formatted alternate rows with slightly different colors. When my colleague opened the ...
3
votes
1
answer
368
views
Excel file links through SharePoint
I'm working for a small company which manages it's knowledge throughout Excel files.
Some of the files contain data from other files, for example our orders file contains products that are saved in ...
3
votes
1
answer
208
views
How to define range of rows in excel while using a formula
I'm using a simple Euclidian distance formula sqrt((a-b)^2 + (c-d)^2) and I have more than 60,000 data in my each excel sheet. Instead of dragging mouse (which is very inconvenient for this large ...
3
votes
1
answer
2k
views
Excel Not Rendering Correct Page Layout in Protected View
One of the employees at my company is trying to publish some Excel files to our website (employee login only). The spreadsheet is rather large (12 columns wide), but there are no plans to convert it ...