Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
0 answers
How to automatically jump to another cell after hitting enter
Hello All, is there a way to automatically move from the current cell to a specified cell after pressing enter or tab? For example: After entering data in cell H2 and pressing enter, cell H3 is selected. If I press tab, then cell I2 is selected. …
Excel
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,599 questions
asked 2024-05-17T21:01:24.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Constance Fischer
0
Reputation points
edited the question 2024-05-17T22:06:40.5766667+00:00
Constance Fischer
0
Reputation points
1 answer
Issue with Excel Destination character size in SSIS
I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…
asked 2024-05-17T11:41:58.3833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dhanvi Bansal
0
Reputation points
answered 2024-05-17T17:56:33.1666667+00:00
Olaf Helper
41,006
Reputation points
1 answer
Creating a link from a word doc to a specific excel cell
Hi, I'd like to create a link from a word document to a specific cell in a workbook sheet. I have tried \ work book address #gid=.'pagename -'!$A$160. which initially takes me to the correct cell but I get a pop up box saying "reference isn't…
asked 2024-05-17T12:10:10.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 37%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kirsten Affleck
0
Reputation points
answered 2024-05-17T17:55:53.1733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 13%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gowtham CP
1,010
Reputation points
0 answers
Print preview not matching document (inserted cell images)
I'm trying to create a document that will build an overall image based on smaller images in cells, but when I print, gaps will appear along row lines of the image (see 2nd image with highlighted areas). Any idea why this is, or if they can be eliminated?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 36%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to create a conditional Format that changes colour the closer it gets to a deadline?
Hello! I am trying to create a conditional format that changes colour 3 times , to a deeper shade each time the real time date changes, and is closer to the dead line, the deepest shade being the day of. lightest shade >7 days to complete middle…
asked 2024-05-16T13:32:03.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 54%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Lo's Pharmacy
20
Reputation points
commented 2024-05-17T12:49:47.08+00:00
Lo's Pharmacy
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Copy and past embedded images from one Excel file to another with Microsoft Graph on Sharepoint
Hello, Is there a way to copy and past embedded images from one Excel file to another with Microsoft Graph on SharePoint? I was able to copy the data from one Excel file to another with the following script but the format is not preserved and the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 30%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
In excel, it is very hard to find the mouse stays in that cell, how to solve it?
In excel, the cell where the mouse is located will be identified with a thin black box, please, is there any way to modify the color and line thickness of this thin black box, so that the user can easily identify the mouse to stay in that cell? Thank…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,341 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,559 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,017 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,653 questions
3 answers
Excel loosing trusted locations
Recently a client started having a problem where Excel 2021 is loosing its trusted locations for common things. Such as c:\users\username... People cant open excel files from their documents folder, downloads, server Z: drive. All of a sudden it causes…
asked 2024-05-08T14:20:32.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 43%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bob Karon
21
Reputation points
commented 2024-05-17T07:43:21.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
3 answers
Excel cells maximum sum
Good evening to all, In excel in cells F8:F9 we have the numbers 17 and 11 respectively (sum 28), in cells M8:M9 we have the numbers 14 and 9 respectively (sum 23) and in cells T8:T9 we have the numbers 17 and 14 respectively (sum 31). I am looking for…
asked 2024-05-08T21:45:29.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 6%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Νικόλαος Γιαννέλος
0
Reputation points
commented 2024-05-17T07:18:53.6366667+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
How to convert Tint value with base color to System.Drawing.Color using OpenXml Library in C#?
Using OpenXml library i want to get the cell background color. when i tried with the below code i did not get the actual color of cell background. Please help me on this. private static BooleanResult<System.Drawing.Color>…
asked 2024-05-17T06:51:04.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 79%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pritam Adak
0
Reputation points
asked 2024-05-17T06:51:04.5666667+00:00
Pritam Adak
0
Reputation points
0 answers
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm)
I am unable to refresh an excel spreadsheet pulling the data from Access Database. [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm) I can refresh other spreadsheets from the same access…
asked 2024-05-16T12:24:00.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 73%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Trickett-Bell, Andrew
0
Reputation points
commented 2024-05-17T05:35:58.73+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
1 answer
when i paste a cell it results wrong value
when i paste a cell it results wrong value
asked 2024-01-30T15:57:35.8466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEJ%3C/text%3E%3C/svg%3E)
evelin john
0
Reputation points
answered 2024-05-17T02:34:17.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
S.Sengupta
15,601
Reputation points MVP
1 answer
Files that are encrypted through the sensitivity label.
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…
asked 2024-05-16T18:58:07.4566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 17%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIN%3C/text%3E%3C/svg%3E)
Iniobong Nkanga
1,681
Reputation points
answered 2024-05-17T02:31:41.2166667+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
macOS Excel v16.85 truncates string size to 126 characters for custom property values
In the latest release of Excel M365 for macOS (v16.85) we are experiencing an issue where when we use the Excel Javascript API via an add-in application to retrieve custom property values, where each custom property is truncated to 126 characters. We…
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,916 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
895 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,559 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
470 questions
asked 2024-05-16T20:50:25.2666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Colby Timm
0
Reputation points
edited the question 2024-05-17T01:23:10.41+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
0 answers
Office Script to delete all rows in a table receives timeout error
I have an office script that is designed to delete all rows in a table. When I run it for 50 or less rows it runs with no problem, but times out when I test it for a larger number of rows (~600). Once this project is live I anticipate the table will…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,559 questions
asked 2024-05-16T14:08:07.1333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wewillendure
0
Reputation points
edited the question 2024-05-17T01:10:48.44+00:00
Jiajing Hua-MFST
5,475
Reputation points Microsoft Vendor
1 answer
HELP!!! MS Excel (MS 365 Family) on a Mac keeps lagging
Hello, Every 3-5 minutes the cursor my MS Excel would convert to the rainbow spinning wheel of death for about 30 second, which is extremely unproductive. Not to mention frustrating. During these lags, Activity Monitor shows MS Excel %of CPU…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
470 questions
asked 2024-05-10T02:44:21.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 66%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Wong
5
Reputation points
edited a comment 2024-05-16T19:34:55.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 85%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PM
0
Reputation points
1 answer
New version of excel is having permission issues with opening some files
Hello Please i need help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files. Had to roll back to the older 16.84 version for it to work.
asked 2024-05-15T16:58:34.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
266
Reputation points
commented 2024-05-16T18:04:13.4433333+00:00
IniobongNkanga-8038
266
Reputation points
1 answer
Can't upload excell to teams and open that excell
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,202 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
asked 2024-03-07T11:24:52.5933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ronda Janjetich
0
Reputation points
edited a comment 2024-05-16T12:57:44.8833333+00:00
Ronda Janjetich
0
Reputation points
1 answer
FORMS: How do I create a registration form in Excel and be able to use it on Apple iPads for student sign in?
Hi all - I need some help, pretty please! I have a sign in form I have created using VBA in Excel and it works great (my first one). The form contains boxes for Name, Cell, Email, a checkboxes question, a dropdown question and an options question - and…
asked 2024-05-14T12:34:44.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 94%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
K Williams
0
Reputation points
commented 2024-05-16T12:20:24.57+00:00
K Williams
0
Reputation points
1 answer
One of the answers was accepted by the question author.
sharing out spreadsheet tasks
Hi I have a SharePoint site where the different owners of the project each have their own titles. There is a master RAIDD (Excel spreadsheets) where different people are assigned tasks. I'd like it so the master spreadsheet is updated but then in each of…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 33%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)