If you’d like to batch open multiple hyperlinks in Excel, you can refer to this article. Here we’ll introduce you 3 handy methods. Each of them has its pros and cons. You can choose any as per your needs.

In some cases, when viewing an Excel file that consists of lots of hyperlinks, you may wish to batch open multiple hyperlinks. If there are only three or so links to be opened, you can just use the Method 1 below. Yet, if you want to batch open all links in your wanted ranges, you can use Method 2 instead. Of course, sometimes, you may wish to batch open all links scattered around the entire workbook. Then, you can use the last way.

Method 1: Manually Open Hyperlinks One by One

To open a hyperlink in a cell manually, you can directly click on the cell. Hence, if there are not too many hyperlinks to be opened, you can click on the cells to open the hyperlinks one by one.Click Cell to Open a Hyperlink

Method 2: Batch Open Hyperlinks in Selected Ranges

Yet, at times, you wish to batch open all the hyperlinks in the selected ranges. In this case, you can actually make use of the following VBA code.

  1. First off, trigger VBA editor in the current Excel file according to “How to Run VBA Code in Your Excel“.
  2. Then, put the following code into a module or project.
Sub BatchOpenHyperLinks_SelectedRanges()
    Dim objSelectedRange As Excel.Range
    Dim objHyperlink As Excel.Hyperlink

    'Get selected ranges
    Set objSelectedRange = Excel.Application.Selection
    For Each objHyperlink In objSelectedRange.Hyperlinks
        objHyperlink.Follow
    Next
End Sub

VBA Code - Batch Open Hyperlinks in Selected Ranges

  1. After that, add this macro to Quick Access Toolbar or ribbon.
  2. Finally, you can select the desired ranges and click the macro button.Select Ranges and Run Macro
  3. At once, all the hyperlinks in the selected ranges will be opened in the default internet browser.Opened Selected Hyperlinks

Method 3: Batch Open All Hyperlinks in a Workbook

Sometimes, you may want to open all the hyperlinks in a workbook, no matter in which worksheet. In this situation, you can use the VBA code instead.

  1. At first, put the following code into a module or project in VBA editor.
Sub BatchOpenHyperLinks_Workbook()
    Dim objWorksheet As Excel.Worksheet
    Dim objSelectedRange As Excel.Range
    Dim objHyperlink As Excel.Hyperlink

    'Process each worksheet
    For Each objWorksheet In ThisWorkbook.Sheets
        For Each objHyperlink In objWorksheet.Hyperlinks
            objHyperlink.Follow
        Next
    Next
End Sub

VBA Code - Batch Open All Hyperlinks in a Workbook

  1. Then, press “F5” to run this macro right now.
  2. Immediately, all the hyperlinks in each worksheet will be opened.All Hyperlinks in the Workbook Are Opened

Repair Excel Issues

Like Word documents, Excel workbooks are very vulnerable. That is to say, Excel files can be corrupt for multiple factors, including virus infection, human errors and Excel crashes and so on. Hence, you should prepare a powerful Excel fix tool, such as DataNumen Excel Repair, which can recover Excel data without breaking a sweat.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf recovery and outlook repair software products. For more information visit www.datanumen.com

             

Have you ever confronted the problem that Windows gets stuck at 10%, 50% or 99% of “Resetting this PC”? Being stuck in this course blocks your PC from booting up normally. Yet, don’t panic. You can use the 6 solutions in this post to fix it.

When you come across the issue that Windows gets stuck on “Resetting this PC”, don’t be panic. As long as you take the following 6 troubleshooting solutions, you can get rid of it as soon as possible. Now, read on to get them in detail.

Windows Gets Stuck on "Resetting this PC"

1. Leave PC Running Overnight

In some cases, it seems that the “resetting this pc” progress is indeed quite slow. Under this circumstance, you can just leave it running for some hours, such as overnight. At times, it may finish on its own. But, if it is stuck on the same percentage, you’d better take the following measures.

2. Startup/Automatic Repair

Moreover, you can attempt to fix this issue via “Startup/Automatic Repair” tool. It can be triggered via the Windows installation media or a bootable external drive.

  1. First off, insert the bootable media into your PC and boot from it.
  2. Then, select “Repair your computer” > “Troubleshoot” > “Advanced options” > “Startup Repair”.
  3. When it completes, you can try to restart your PC to see if error persists.

3. Command Prompt

Also, since the problem may occur from corrupted boot configuration data, you can run command prompt to rebuild and fix it.

  1. At first, like the above solution, reboot PC from a bootable drive.
  2. Then, click “Repair your computer” > “Troubleshoot” > “Advanced options” > “Command Prompt”.
  3. Next, in the popup Command Prompt, run the following commands in turn –¬†bootrec /fixmbr
    bootrec /fixboot
    bootrec /scanos
    bootrec /rebuildbcd
  4. Eventually, after that, reboot PC in a normal status.

4. System Restore

This trouble may result from the system failures. Therefore, it is also a solution to revert the current system to a previous system point. Of course, it demands that you have enabled “System Restore” feature before.

5. Reinstall Windows

Furthermore, assuming that the solutions above don’t work, you have no choice but to reinstall the Windows system. If you do not know how to properly do that, you are better off contacting relevant professionals for help.

6. Third Party Tool

Last but not least, aside from Windows reinstallation, you can also make use of a third party utility. There are multiple such tools available in today’s market. Thus, you can easily find one. But, you should beware of the unreliable software from unknown sources in that they may destroy your data, like corrupt Outlook files, without letting you know.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including SQL Server corruption and outlook repair software products. For more information visit www.datanumen.com

             

If you want to quickly get the data size of each worksheet in an Excel workbook, you can refer to this article. Here we will share 2 handy methods with you.

At times, when dealing with an Excel workbook which consists of a great amount of worksheets, you may want to get the data size of each worksheet. However, there is not a native feature for this requirement. So, you need to use some workarounds, such as the following Method 1. Or you can use the much smarter Method 2 to get all worksheets’ data sizes in bulk.

Method 1: Get Worksheet Data Size One by One Manually

  1. At first, open the specific Excel workbook.
  2. Then, copy the contents of an Excel worksheet.Copy Sheet Contents
  3. Next, create a new workbook and paste the copied worksheet into Sheet 1.Paste Copied Worksheet
  4. Later, save the new workbook to a Windows folder.Save New Workbook
  5. Lastly, you can check the new workbook’s data size, equal to the worksheet’s data size, in Windows Explorer, as shown in the following screenshot.Get Data Size in Windows Explorer
  6. Now, you can use this way to get the data sizes of other worksheets one by one.

Method 2: Batch Get the Data Sizes of All Worksheets via VBA

  1. To begin with, open the Excel VBA editor according to “How to Run VBA Code in Your Excel“.
  2. Then, put the following code into a project or module.
Sub GetEachWorksheetSize()
    Dim strTargetSheetName As String
    Dim strTempWorkbook As String
    Dim objTargetWorksheet As Worksheet
    Dim objWorksheet As Worksheet
    Dim objRange As Range
    Dim i As Long
    Dim nLastEmptyRow As Integer

    strTargetSheetName = "Sheet Sizes"
    strTempWorkbook = ThisWorkbook.Path & "\Temp Workbook.xls"

    With ActiveWorkbook.Worksheets.Add(Before:=Application.Worksheets(1))
         .Name = strTargetSheetName
         .Cells(1, 1) = "Sheet"
         .Cells(1, 1).Font.Size = 14
         .Cells(1, 1).Font.Bold = True
         .Cells(1, 2) = "Size"
         .Cells(1, 2).Font.Size = 14
         .Cells(1, 2).Font.Bold = True
    End With

    Set objTargetWorksheet = Application.Worksheets(strTargetSheetName)

    For Each objWorksheet In Application.ActiveWorkbook.Worksheets
        If objWorksheet.Name <> strTargetSheetName Then
           objWorksheet.Copy

           Application.ActiveWorkbook.SaveAs strTempWorkbook
           Application.ActiveWorkbook.Close SaveChanges:=False

           nLastEmptyRow = objTargetWorksheet.Range("A" & objTargetWorksheet.Rows.Count).End(xlUp).Row + 1

           With objTargetWorksheet
                .Cells(nLastEmptyRow, 1) = objWorksheet.Name
                .Cells(nLastEmptyRow, 2) = FileLen(strTempWorkbook)
           End With

           Kill strTempWorkbook
         End If
    Next
End Sub

VBA Code - Get the Data Size of Each Worksheet in an Excel Workbook

  1. After that, press “F5” to run this macro right away.
  2. Eventually, after macro finishes, back to the workbook.
  3. You’ll see a new worksheet at the very beginning, which contains the size of each worksheet, like the following image.New Sheet with Size Information

Comparison

  Advantages Disadvantages
Method 1 Easy to operate Too troublesome if there are too many worksheets in the current workbook
Method 2 Easy and convenient no matter how many worksheets exist in the workbook Perhaps the above VBA code is a bit incomprehensible for newbies

Fix Exasperating PST Issues

Users can encounter all kinds of disturbing troubles in MS Excel, ranging from unexpected shutdown or restart to severe xlsx corruption. Unquestionably, the most knotty problem is damaged Excel file in that it cannot be resolved easily. It demands you to apply an external Excel fix tool, like DataNumen Excel Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupt SQL Server and outlook repair software products. For more information visit www.datanumen.com