Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [microsoft-excel]

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, sorting and filtering data, pivot tables and a macro programming language called Visual Basic for Applications (VBA).

Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and macOS. It features calculation, graphing tools, sorting and filtering data, pivot tables and a macro programming language called Visual Basic for Applications (VBA).

Questions on serverfault should be about management estates of many Excel instances, Excel formulas on superuser and coding with VBA on stackoverflow

89 questions
0
votes
1 answer

Exporting XML Spreadsheet as XML data from Mac Microsoft Excel 2011

I want to use an XML file to facilitate data imports into an Oracle APEX application. The primary reason why I want to use XML is that some of the fields in the Excel spreadsheet could contain many commas which would plague a Comma-separated-value…
Chris Dix
  • 11
  • 1
  • 4
0
votes
1 answer

"An error has occurred" when opening xlsx files on Sharepoint 2010

We just recently installed and have been using SharePoint 2010 and have run into a bit of a problem opening Excel spreadsheets with the xlsx extension. We are able to upload a spreadsheet with the xlsx extension, however, when we attempt to download…
Mike Messina
  • 89
  • 4
  • 12
0
votes
1 answer

SSIS Foreach loop (SQL Server 2005) adding loop variable causes failure

I'm trying to use SSIS to traverse a directory of Excel files and put them into a table in SQL Server. I seem to have a basic choice - either I get the same spreadsheet dumped in the table 10 times or I get an error message. I'm using the…
alimack
  • 943
  • 2
  • 11
  • 22
0
votes
0 answers

System.EnterpriseServices Error when trying to connect Excel or PowerBI to a SQL Server

I just setup a new SQL server and am trying to connect Excel and PowerBI to it. I'm getting an error that says the following: Unable to connect Details: "An error happened while reading data from the provider: 'Could not load file or assembly…
JKith
  • 1
0
votes
0 answers

Deploy Office Add-In for Excel with Office Store Globally Disabled?

I have been struggling for ~5 months to get help on GitHub as I'm unable to deploy my Office-JS App via out internal MS365 Admin Center. Most recently, my question/concern is if it is possible to deploy a "custom/Admin Managed" app while having…
FreeSoftwareServers
  • 515
  • 1
  • 8
  • 26
0
votes
0 answers

How to assign filtered column data to a variable using Set in VBA excel?

I am newbie to VBA excel. I am trying to use Set to assign some data from a filtered column (through AutoFilter) to a variable (X in this case). Below shows the code and image of the table. Sub Test() Dim X As Variant …
Handsome Teh
  • 9
  • 1
0
votes
0 answers

Who really has this Office document on a NAS shared folder open?

I've encountered this before, but this is the first time I decided to ask about it. One of my managers (call them M) wanted to open an Excel document on a shared drive. Excel told them that user A already had it open for editing. User A was on…
Spencer
  • 197
  • 1
  • 9
0
votes
1 answer

Excel not opening files intermittently

We have a strange problem with Excel in the last couple of weeks, where files don't always open & it can take up to 6 attempts. So far it's affected 3 PCs that I know of, all running Windows 11 and excel version 2210 Build 16.0.15726.20188…
Lolly
  • 3
  • 2
0
votes
1 answer

Why does writing to a workbook of a few MB with Python's openpyxl module eat Gigabytes of RAM?

I found an old code on a legacy server that writes from a dataset of roughly 20 columns and >60K rows item by item to an Excel file using openpyxl. It does this by filling each cell on its own (the slow way, but not that slow either since the whole…
questionto42
  • 353
  • 5
  • 23
0
votes
1 answer

Excel 2019 opens any document in Read-Only mode on a terminal server

We have a terminal server (Server 2012 R2) used by ~10 people. When any user (including Administrator) opens an Excel file (xls / xlsx), it will open in read-only mode. This could be a file within a share that has full permissions for all users, or…
user2924019
  • 99
  • 1
  • 12
0
votes
1 answer

Is there any solution out there that is as easy to use as power query but handles 2gb of data?

I created an excel sheet that using power query and vba generates access keys and makes api calls to my crm to download all data. Unfortunately excel in desktop doesn't allow me to make the data accessible via web or app so employees can all real…
Yerry Balenzuela
  • 1
0
votes
1 answer

Active directory from VBA Excel 2016

I need to know how to get the result in VBA Excel from Active Directory using shell, cmd, dsquery and dsget filtering by email in this way: ---> dsquery user -name m * | dsget user -email If I write the above commands in a cmd (it doesn't need admin…
ttlecaster
  • 1
  • 1
0
votes
1 answer

Unable to Use Imported SPC Certification To Sign VBA File

I have a tricky issue, I'm trying to install a certificate to sign a VBA file. I've purchased a third party certificate and followed the instructions here to install it and sign my VBA file with it. However, I'm getting the following error when I…
David Rogers
  • 215
  • 2
  • 11
-4
votes
2 answers

Check a list of passwords strength

Is there any way to check a list of passwords whether they strong or not? I have a list of passwords, around 2000, and want to check them against this policy Password must contain a minimum of eight (8) characters Password must contain at least…
user144705
  • 9
  • 1
  • 2
1 2 3 4 5
6