Install Excel
Kym Cavrak
I have even tried to install the 32-bit Microsoft Access Database Engine 2016 Redistributable driver, but get a setup error message that I cannot install the 32-bit version because I currently have 64-bit Office products installed.
I'm using 3.0.2, but I was able to load excel tables in previous 3.0 versions. I have this post stickied and will keep my eye out for any solutions. If I find out anything, I'll reply with the solution.
I tried this and then received an error message for the first time indicating the x64 driver wasn't installed. Perhaps, because I was doing so many uninstalls/reinstalls/silent installs, etc., I managed to forget to reinstall the x64 driver first.
Hi Todd. I had the same problem and now have both drivers installed. Now ArcMap crashes when I try and open an Excel file despite working fine before I installed the x64 driver. I'm wondering if you have ArcMap installed too and have the same issue?
I am having the same issue. I have reinstalled the x64 driver twice and rebooted but still no luck. Also, when trying to add the excel table, ArcGis Pro (version 3.02) keeps spinning, and if I cancel the upload it goes into a weird status. Everything is greyed out in the menu, and cannot even save and/or exit the file or the program. At that point, I can only kill the task from the task manager. I also do have ArcMap but not the x32 driver installed.
Would greatly appreciate any help/suggestion of what else to try. Getting highly frustrated and annoyed by the time wasted with no pop-up window or any other type of indication of the error.
Many thanks in advance -
You won't see Power Query as an add-in because it hasn't been for some years now, it's baked right into the application. You see it on the Data tab in the 'Get & Transform Data' group of commands. Since you see those ribbon controls, you have Power Query. It's confusing since it actually started as an add-in originally.
To your question, perhaps you don't have MS Query installed? That would be the first thing I would check. To check this, go to your Contol Panel > Programs and Features > right-click Office and select Change > Select Add or Remove Features, make sure MS Query is there. I'm honestly not sure where to go from there. A cursory web search didn't turn up much else than checking if it was installed and forcing updates. My over-arching question is: why do you even want to use MS Query with so many other amazing tools at your fingertips??
@AOM_LV That is strange indeed. The only other thing I would try, although I've only heard of this as an issue and never seen it first hand, would be to try opening a blank query in different file formats. I'd guess it wouldn't work no matter the file type (xlsx/default, xlsm, xlsb). If that fails, the only things I can recommend are:
Try an office repair
This certainly sounds like a technical issue. My dealings with these sort of things in the past has been to more or less remove Office completely, including some registry settings for saving login information (Office trying to be helpful) and do a full clean install. I'm not sure how much further help I'll be here.
So how you install these addins (as the local user with admin rights or an administrator) can affect how it is deployed so when you right click and run as admin it actually installed the plugin in the admin user profile not the local user that you wanted.
What I usually do is give the user you need to install this plugin for local admin rights to the box temporarily, install the plugin and then remove them from local admin. This usually will get you to where you need to be with these more complex plugins.
Would you please explain more about this? The problem should be in the computers of the users? since it works always for the others? Or should be related with the Dynamics 365 Fin and Ops configuration?? or with the Office Admin center?
To configure and perform deployments of Office LTSC 2021, including Project and Visio, for users in your organization, you use the Office Deployment Tool (ODT). The Office Customization Tool (OCT) that you previously used for Windows Installer (MSI) is no longer used.
The installation files for Office LTSC 2021 are available on the Office Content Delivery Network (CDN) on the internet instead of on the Volume Licensing Service Center (VLSC). You can install Office LTSC 2021 directly from the Office CDN. Or, you can download the installation files from the Office CDN to a location on your local network, such as a shared folder, and install Office LTSC 2021 from that location. You can use different methods for different sets of devices in your organization. Whichever method you choose, you use the ODT.
Installing directly from the Office CDN requires the least amount of administrative effort and is recommended. But you might have constraints that prevent you from installing directly from the internet. For example, some devices might not have connectivity to the internet or you might have limited bandwidth to the internet.
After you download the Office Deployment Tool, double-click on the officedeploymenttool executable (.exe) file to extract the ODT files. When you're finished, you should have several files: setup.exe and some sample configuration.xml files. For an Office LTSC 2021-specific sample, see Sample configuration.xml file to use with the Office Deployment Tool.
The setup.exe file is the ODT and is a command-line tool that supports downloading and installing Office LTSC 2021. The configuration.xml files are sample files to get you started. You use the configuration.xml file to provide settings for the ODT to use when downloading or installing Office LTSC 2021. The configuration.xml is a simple xml file that can be created and edited in any text editor, such as Notepad. You can name the file anything that you want, as long as it retains the xml file extension.
Once you have a copy of the ODT, you need to create a configuration.xml file. You can create multiple configuration.xml files to be used with the ODT. For example, you can create a configuration.xml file to download and install the 64-bit version of Office LTSC Professional Plus 2021 in English. Then, you can create a different configuration.xml file to install the 32-bit version of Visio LTSC Professional 2021 in French. When you run the ODT from an elevated command prompt, you specify which configuration.xml file to use.
There are a series of settings in the configuration.xml file that you configure to customize the Office LTSC 2021 download or installation. The following table lists the most common settings to configure in the configuration.xml file.
We recommend that you uninstall any previous versions of Office before installing Office LTSC 2021. To help you uninstall versions of Office that use Windows Installer (MSI) as the installation technology, you can use the ODT and specify the RemoveMSI element in your configuration.xml file.
For more information about using RemoveMSI, see Remove existing MSI versions of Office when upgrading to Microsoft 365 Apps. Even though that article is about Microsoft 365 Apps, most of the information also applies to Office LTSC 2021.
To uninstall 2019 versions of Office, Visio, or Project from the device, use the Remove element. You use the Remove element because 2019 versions of Office, Visio, and Project are installed by using Click-to-Run, not Windows Installer (MSI).
Once you have a copy of the ODT and have created your configuration.xml file, you can download the Office LTSC 2021 installation files to your local network. To do that, open an elevated command prompt, go to the folder where you saved the ODT and the configuration.xml file, and type this command:
Once you have a copy of the ODT and have created your configuration.xml file (and downloaded the Office LTSC 2021 installation files to your local network, if necessary), you can install Office LTSC 2021. To do that, open an elevated command prompt, go to the folder where you saved the ODT and the configuration.xml file, and type the following command:
You can also use Microsoft Configuration Manager (current branch) to deploy Office LTSC 2021. The Office 365 Client Installation wizard steps you through the process and builds the configuration.xml file for you. There's an entry for Office LTSC Professional Plus 2021 in the wizard. On that same page, you can also select to deploy Project and Visio. To get to the wizard, in the Configuration Manager console, navigate to Software Library > Overview > Office 365 Client Management.
Office LTSC 2021 no longer includes the Teams client app. However, if the Teams client app was previously installed with Office LTSC 2021, it will continue to be automatically updated approximately every two weeks with new features and quality updates. The update process for Teams is different from the update process for other Office apps, such as Word and Excel. For more information, see Teams update process.
I want to try this add-in for Excel. To use the add-in there must be an XLAM file. However, there is no link to one on the website (xlwings.org). Even using pip to 'download/install' xlwings, it doesn't include the command client that the documentation claims it does. As such, there is no possible way on the user end to get xlwings that we can determine.
Using command prompt doesn't work. We have all the files, however. I see the directory, including the quick start macro. But command prompt will not execute xlwings or any other command, thus rendering the module unable to be used.
d3342ee215