office-excel-itpro Image

office-excel-itpro

Technical questions about Microsoft Excel - IT Pro, the industry leading spreadsheet program, a powerful data visualization and analysis tool.
question
JonathanBrotto-3536 avatar image
JonathanBrotto-3536 asked VishalShahN answered

xlookup not accent sensituve

office-excel-itpro

0 Votes

1Answer

3 Comments

question
EavenHuang avatar image
EavenHuang asked emizhang-msft commented

excel tricks to remove spaces at the beginning and ending of the cells?

office-excel-itpro

0 Votes

2Answers

0 Comments

question
oemScript avatar image
oemScript asked CeasarChenMSFT-3458 edited

VBA: How to setup connection with Access to retrieve data into Excel?

office-vba-dev office-excel-itpro

0 Votes

0Answers

1 Comment

question
MayChum-9718 avatar image
MayChum-9718 asked emizhang-msft answered

Excel : Images Disappearing/Distorted After Filtering and Deleting Non-Consecutive Rows

office-excel-itpro

0 Votes

3Answers

0 Comments

question
RobinLiang-7103 avatar image
RobinLiang-7103 asked RobinLiang-7103 commented

BUG?--Excel cell format setting dialog cannot drag to move

office-excel-itpro

This question has an accepted answer. Accepted

0 Votes

1Answer

0 Comments

question
CarloBatenb-0761 avatar image
CarloBatenb-0761 asked AllisonCastner-2739 answered

VBA/ Macro blocked on network drive

office-vba-dev office-excel-itpro office-scripts-excel-dev

0 Votes

3Answers

0 Comments

question
pasangkajisherpa-8629 avatar image
pasangkajisherpa-8629 asked Russell-3546 answered

Import data from Web using login details

office-excel-itpro

0 Votes

4Answers

1 Comment

question
ShambhuRai-4099 avatar image
ShambhuRai-4099 asked emizhang-msft edited

Transpose 2 column in one column

office-excel-itpro office-addins-dev office-scripts-excel-dev

This question has an accepted answer. Accepted

0 Votes

2Answers

0 Comments

question
HariKrishna-9174 avatar image
HariKrishna-9174 asked HariKrishna-9174 edited

DocumentFormat.OpenXml.Spreadsheet while copying from existing excel apply validation if existing excel has hyperlinks and datavalidation download file not opened

dotnet-csharp office-excel-itpro

0 Votes

0Answers

0 Comments

question
niftycat555-4426 avatar image
niftycat555-4426 asked CeasarChenMSFT-3458 commented

Power Pivot does not filter correctly

power-query-not-supported office-excel-itpro office-addins-dev

0 Votes

0Answers

2 Comments

question
TonyP-5206 avatar image
TonyP-5206 asked CeasarChenMSFT-3458 edited

Object Does Not Contain a Definition for Open

office-excel-itpro

0 Votes

0Answers

1 Comment

question
Rakhi-6603 avatar image
Rakhi-6603 asked CeasarChenMSFT-3458 commented

OpenXML SDK Comment handling in Excel

office-excel-itpro

0 Votes

0Answers

1 Comment

question
jellyfish-1473 avatar image
jellyfish-1473 asked emilyhua-msft commented

Pivot Table doesn't count all data

office-excel-itpro office-scripts-excel-dev

0 Votes

1Answer

0 Comments

question
AngelaCanady-9853 avatar image
AngelaCanady-9853 asked emilyhua-msft commented

Issue with Excel showing in a cell that it is calculating

office-excel-itpro

0 Votes

2Answers

2 Comments

question
KCSteele-8724 avatar image
KCSteele-8724 asked WendyLi-MSFT edited

How to list document links to files via VBA

office-vba-dev office-excel-itpro

This question has an accepted answer. Accepted

0 Votes

2Answers

0 Comments

1101 Posts
987 Users
54 Followers