Excel Not Responding When Running Macros (9 Possible Solutions)

Overview Getting the following pop-up when running macros? Large files, internal code issues, and complicated macros are just a few things that can ...

How to Undo Changes in Excel after Save and Close (2 Methods)

Let's use a sample dataset that contains columns for Employee Name, Department, and Salary data. We'll make some changes and undo them after you've ...

Excel VBA: Unprotect Workbook with Password: 7 Practical Methods

Method 1 - Unprotect a Single Workbook with a Password in Excel VBA Task: Unprotect the workbook named workbook_1.xlsx inside the Exceldemy folder ...

How to Recover Corrupted Excel File (8 Possible Ways)

Method 1 - Using the Open and Repair Tool of Microsoft Excel STEPS:  Go to the File tab > Open. Set the file destination in the ...

How to Transpose Rows to Columns Based on Criteria in Excel (2 Ways)

Download the Practice Workbook Transpose Rows to Columns with Criteria.xlsm 2 Handy Approaches to Transpose Rows to Columns Based on ...

Copy Table from PDF to Excel with Formatting (2 Effective Ways)

The table is in a PDF, and our goal is to copy the table from PDF to Excel with formatting. Method 1 - Importing Data from PDF and Copy a ...

How to Copy Excel Table to Word with Gridlines (2 Simple Methods)

This article will show you how to copy table from Excel to Word with gridlines with proper illustrations. How to Copy Table from Excel to ...

[Fixed!] Excel Attachments Not Opening from Outlook (6 Quick Solutions)

The sample dataset contains the dataset of 10 fruit items and their amount. The name of the fruit items is in column B, their quantity is in column ...

[Fixed!] Excel Keeps Crashing When Opening File (11 Possible Solutions)

  Solution 1 - Start Excel in Safe Mode    Steps: Press and hold down the Ctrl key when starting Excel. Press 'Windows ...

How to Fix Excel Not Responding Without Closing (16 Possible Solutions)

Method 1 - Wait till Excel Responds Again You may not want to close excel when it stops responding because you do not want to lose your unsaved ...

Excel VBA: Protect Sheet with Password and Allow Filter

In this article, I’ll show you how can protect an Excel sheet with a password and also allow the filter there using VBA. Excel VBA: Protect ...

[Fixed!] Protect Workbook in Excel Not Working (with Quick Solution)

In the dataset, we have a .csv file that contains sales information of a store in a week. We will apply protection on this file. Protect ...

Macro to Convert Excel to Pipe Delimited Text File (3 Methods)

We have the following dataset. The contents of the dataset are relatively irrelevant to the code we'll use. Method 1 - Macro to Transfer ...

How to Protect Excel Cells from Being Edited (6 Suitable Methods)

When you work with an important dataset in your Excel including formulas, you need to protect those cells from being edited. Any alteration of your ...

How to Split Column in Excel Power Query: 5 Easy Methods

Method 1 - Using Delimiter Command to Split Column in Excel Using Power Query Step 1: Select your entire data range from your dataset. Select ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo