Hyperlink to .bat file within an Excel file, no longer works. "No Program is registered to open this file"

microsoft-excel batch hyperlink links

Solution 1:

Have you installed any software before this issue?

I suggest you locate to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.bat, check whether there is any other program associated with .bat file.

  1. If yes, you may backup the registry of .bat first, and restore .bat files with default settings.

Generally, the default registry entries are OpenWithList and OpenWithProgids, for more you may refer to following images.

enter image description here

enter image description here

  1. If not, I suggest you add the path of these bacth files into Excel Trusted Location. (File > Options > Trusted Center > Trusted Center Settings > Trusted Locations > Add new location).

Run SFC scan.

  • Search "Command Prompt", right-click it, run as Administrator.
  • Click Continue or supply Administrator credentials if prompted.
  • In the Command Prompt window type the following, and press Enter: sfc /scannow

Related

How would I set a custom "domain name" of sorts for a LAN server?
How can I convert "norms" using the bijection between $\mathbb{N}$ and $\mathbb{Z}^{d}$?
Is correct to say $H\times K$ is a subgroup of $G$ and its order is $q$? [closed]
evaluate $\int_{0}^{1}dx \frac{(1-x)x(1+x)}{x^2+(1-x)a^2}$
When are Differentiation and Integration Inverse Operations?
Does the Axiom of Choice give the strategy function for the existential quantifier in all formulas?
Expand the incomplete gamma function $\int_0^x e^{-t}t^n dt$
Showing that $a \times [a \times [a \times (a \times b)]]=x^4 b$ where $x = \| a \|$
Prove that there exists a sequence $\{x_n\}_{n \in \mathbb{N}} \subseteq A$ such that $\lim_{n \to \infty} x_n = I$
A variant of the ode $\dot x=y, \dot y=-x$
Is there a function that maps all integers from $1$ to $m\cdot n$ in ascending order to an $m\times n$ matrix?
How do I construct charts that are used to form an atlas that covers the real projective space ${\mathbb{P}}^n$?