Explore Excel on Experts Exchange

Expert Solutions for Your Tech Problems

ExcelMicrosoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...

Read more
  • 144K Content
  • 12K Contributors

Expert Spotlight
Finance Analyst

30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.

Troubleshooting Question

SQL Workbench (Mac) - What is the max record size?

I have trouble using Excel to Import from a CSV file, due to the large size. I tried to filter on

Troubleshooting Question

Modify Excel cell and reformat assistance.

3

I have an excel field with a phone number like this: (605) 333-0071


How do I remove the paraenesis,

Troubleshooting Question

Can Excel display the the number of rows?

3

I see Mansfield has 10 rows, and Oxford has 2 rows.


What Excel formula would calculate and display 10

Troubleshooting Question

Excel: I need to Transform the CSV import to reduce the size of the set

4

The file is a CSV and I imported from a small version of the file, which was 72KB. I imported in

Troubleshooting Question

Import new CSV file data in to an existing Excel workbook with predefined formats

1

I have an Excel Worksheet ( cal_cost.xlsx ) with predefined column headers. Some examples of the

Troubleshooting Question

vba to create a folder based on a path in the open workbook cell

byEuro5
2

I want to use vba to create a folder based on a path saved in the 

Open workbook, 

Troubleshooting Question

SharePoint Issue with Excel sheet with hyperlinks

2

Hello,

 

We have an Excel spreadsheet within a SharePoint folder that for whatever reason the

Troubleshooting Question

Moving rows by value

1

Hello,


I got the following from youtube and added to it to meet my needs (just added a little bit.)

Advice Question

Excel Data Model - Equivalent of vlookup in worksheet table to cross-ref Data Model Table

I have a table in the data model (loaded from a query) with only 2 columns: (1) ID, which is a text

Troubleshooting Question

Highlight Closest Value based on another cell value.

7

I have a number in cell M14 and a table with a range of a3-j3 (this includes headers) that can

Troubleshooting Question

EXcel first in first out 12 month expiration time

byTom M
12

Column a is the month, Column b is the monthly Generation credits and Column c is the month amount

Troubleshooting Question

Converting Cells with Excel formula into Power Query

Hello, 

I'm new to Power Query.  I'm working on a project where I still need to convert formulas I

Troubleshooting Question

macros not digitally signed in excel 2003

3

A customer of mine, running windows 7 with microsoft excel 2003 had me change his hard drive to a

Research Question

Looking for afterhour input excel template

1

Hi experts,

I need help from the IT professionals to check if anyone is using excel file to track

Troubleshooting Question

Create Hyperlink to Excel Sheets on Sheet 1

4

I have created some code with Python that extracts historical stock data. I want the first page to

Advice Question

Programmatically access Microsoft 365 Copilot from an Office Add-In

2

As a C# developer with experience using VSTO to create add-ins for Excel and Word, I'm very

Troubleshooting Question

Is there a way or workaround to auto refresh the excel file without opening it ?

8

Hello,

Is there a way or workaround to auto refresh the excel file without opening it ?


Thank you.

Troubleshooting Question

Excel VBA Code - Copying Image To Wrong Sheet

8

The following Excel VBA code executes when a spreadsheet is opened on a schedule to achieve.an

Troubleshooting Question

Convert Excel to XSD Schema

3

Experts,


I have to load data into a web-based database where I can enter each record manually by

Troubleshooting Question

Office 365 lost recent and pinned files list

1

I have lost my pinned and recent files list in excel and word 365.  see screenshots of another

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more