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).

Filter by
Sorted by
Tagged with
0 votes
0 answers
91 views

Open Excel from Powershell, running from Task scheduler

What I'm trying to do: I want a scheduled task to refresh Excel queries (ODBC), save them, and email them to clients. What I got so far: I have a PowerShell script that runs opens an Excel file and ...
Omri Liad's user avatar
0 votes
0 answers
70 views

Add ODBC driver for Office 365 (local install) in Windows Server 2016

For some ETL operations using Microsoft's SSIS system, we need to read data from an XLSX file accessible from the database server (Windows Server 2016, Microsoft SQL Server 2017 on prem). When ...
TomS's user avatar
  • 185
0 votes
2 answers
786 views

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 ...
JKith's user avatar
  • 1
2 votes
2 answers
233 views

Convert lscpu output to row based format in excel/csv table format

I have the below data (lscpu output) for 1000 servers and I want the same in excel but in row format and not as in command output in columns 1.2.3.4 CHANGED Architecture: ...
Loki's user avatar
  • 21
0 votes
0 answers
233 views

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 ...
FreeSoftwareServers's user avatar
0 votes
0 answers
136 views

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() ...
Handsome Teh's user avatar
0 votes
1 answer
239 views

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 ...
Lolly's user avatar
  • 3
1 vote
1 answer
572 views

Best way to convert azure logs date time into an excel date time

Hello when I export Azure logs to csv I get this datetime format that excel doesn't recognize as a valid date time format: 2022-10-19T12:05:58Z Is this the best way to convert this to an excel ...
Dave Sopko's user avatar
0 votes
1 answer
2k views

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 ...
questionto42's user avatar
2 votes
1 answer
509 views

Signing Excel .XLSM-documents, expiring code signing certificates and trusted publishers

Short: Is there anyway to trust a certificate or publisher, so that the trust remains even after the certificate has expired? Much longer: We develop (among other things) Excel documents for a number ...
Fredrik Gunne's user avatar
0 votes
1 answer
880 views

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 ...
HippoDuck's user avatar
0 votes
1 answer
57 views

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 ...
Yerry Balenzuela's user avatar
1 vote
1 answer
1k views

Can not run EXCEL.EXE with “runas”, it says: “1312: A specified logon session does not exist. It may already have been terminated.”

I need to run EXCEL.EXE with a user different than current one; previously I have been doing this without any issues using "runas", but after updating the system to Windows 10 Pro version ...
forlayo's user avatar
  • 121
0 votes
1 answer
289 views

Active directory from VBA Excel 2016 [closed]

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 ...
ttlecaster's user avatar
0 votes
1 answer
268 views

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. ...
David Rogers's user avatar
2 votes
2 answers
5k views

Prevent Office apps from saving to OneDrive by default

In an upcoming update to Office 365, desktop apps will default to save in OneDrive rather the local drive or redirected profile. This is obviously going to be a pain to have to teach every user this ...
David Weber's user avatar
0 votes
1 answer
115 views

Office 16 ADMX Policy Won't Pull on GPO

The title might not do my issue any justice, so here goes; Anytime a new user opens an Excel instance, a small dialog pops up asking them to accept the licensing and update terms: The user's first ...
nightsurfer's user avatar
4 votes
2 answers
44k views

What is "Print driver host for applications" and why does it slow down my Excel macros?

I tested this on multiple Windows 10 computers running the latest version of Excel (365 subscription) with both Bluebeam PDF and Microsoft XPS Document writer set as the default printer and get the ...
michaelf's user avatar
  • 141
1 vote
0 answers
54 views

How can a user re-lock an excel file when he isn't here today?

There are a dozen questions already about Microsoft Office files being locked from editing, but not this exact question. So I hope it won't get marked as a duplicate. I went into Computer Management ...
WakeDemons3's user avatar
1 vote
0 answers
492 views

Open Excel files in read-only mode if already open by another user in write mode

I've been all over Google for the past days and I simply can't find a solution to this that would work in this setup. The setup: Windows Server 2012 R2 (RDS), Office 2016, file server is 2012R2. The ...
Mikael Dyreborg Hansen's user avatar
1 vote
0 answers
2k views

Samba file is read only in Windows, even with correct permissions in Linux for Group

Windows keep seeing an Excel file as Read only for Group, the Linux permissions is correct for group to be read write. Server OS Ubuntu 14.04.4, Client OS Windows 10, Samba 4.3.11 This is the Samba ...
Niel Buys's user avatar
0 votes
1 answer
151 views

Mismatch of pin rules for domain

I see some of those logs in my windows eventlog (Windows 10) 05/31/2017 07:44:03 AM LogName=Application SourceName=Microsoft-Windows-CAPI2 EventCode=4114 EventType=2 Type=Error ComputerName=VIE-TABSI-...
gerhard's user avatar
1 vote
0 answers
393 views

GPO Office 2013 Protected View - Unsafe Locations - Blocking Files

I am attempting to force all Excel files in the R:\Folder network map to open in protected view. I set up the GPO and added the path to Unsafe Location #1 GPO Policy: User Config -> Admin ...
Travis's user avatar
  • 870
0 votes
0 answers
58 views

Systematically launch a GUI software in Windows Server

In a calculation provided by my Windows server, I have to make Microsoft Excel involve because of technology limitations: I need to systematically open Excel inside the server, read content of an ...
Thomas's user avatar
  • 223
1 vote
1 answer
1k views

Performance Issues for Excel Relinking in Powershell

We are doing a shared network drive reorganization. This will break links in hundreds of gigs of Excel files that the business uses. In order to soften the blow, I've created a Powershell script that ...
Jonathan Nelson's user avatar
0 votes
2 answers
2k views

Powrshell Script to read the Windows Secutiry logs and filter Elevation type 196 and 1937

I have a powershell script that reads the elevation type and displays the content in powershell window. However I need to put the contents in Excel file. Please help. cls $evtLogEntries=$null $...
Ankit's user avatar
  • 1
0 votes
1 answer
4k views

Intermittent Excel issue of "file locked for editing" not showing when it should

Current setup: 3 app servers (2008 r2, terminal services XenApp 6.5), 2 file servers (2008 r2). Situation: user1 opens up an excel file that is on server1 and starts to work. user2 goes to open ...
soMuch2Learn's user avatar
1 vote
1 answer
404 views

Passing AD identity from Sharepoint Online to Analysis Services Tabular on an Azure VM

We are presenting charts & reports in Excel Services hosted in SharePoint Online. The Excel files in turn connect to an Analysis Services Tabular Model hosted in an Azure VM. In order to use ...
Édgar Sánchez Gordón's user avatar
1 vote
2 answers
2k views

No 'locked for editing' message for an Excel file on a network share

I get no 'locked for editing' message when accessing an Excel spreadsheet file on a network share (Windows SBS 2011 Standard) even though the file is open by a different user on a different ...
Dam's user avatar
  • 11
1 vote
0 answers
195 views

Windows 7 Pro 64-bit Standard User Default Profile: Local Group Policy or Sysprep?

I have a Windows 7 Pro 64-bit machine that will be hosting three Windows 7 Pro 64-bit VMware Player 7 virtual machines. I have the first VM completed and am about to create the first standard user on ...
Bill Vallance's user avatar
0 votes
1 answer
52 views

Office Interope Needs IIS restart-Windows Server2008R2-IIS7

I have an application hosted at Windows server 2008R2 with IIS7 with MS Excel2013 32bit. This application uses Excel application to convert excel sheets to webpages. It works fine until user keeps ...
AddyProg's user avatar
  • 101
2 votes
3 answers
17k views

Batch script to export info from Active Directory (name, phone numbers, location, etc) into a csv file

The secretary at my work uses a spreadsheet that lists names, phone numbers, and locations of employees to look up info if someone asks. All this info is located in AD, but the problem is that we are ...
James F's user avatar
  • 21
0 votes
1 answer
150 views

Excel 2013 Power Pivot RemoteApp - limited by 4 concurrent users? [closed]

We're trying to use Excel 2013 (64bit) + Power Pivot via RemoteApp. The problem we're having is basically the same as described this TechNet thread. 4 concurrent users have no problem using Power ...
Blaž Dakskobler's user avatar
2 votes
2 answers
4k views

Unable to remove "Run this program as an administrator" (greyed out) with Excel 2010

I have issue with one of the user in Terminal Server 2008 R2 who has "Run this program as an administrator" checked and greyed out with Excel 2010. This causes UAC to popup requesting for ...
Sean Hu's user avatar
  • 51
0 votes
1 answer
2k views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
Ewert's user avatar
  • 5
2 votes
2 answers
7k views

Add an Excel file as a linked server in SQL 2012

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you ...
MgSam's user avatar
  • 141
0 votes
1 answer
4k views

GPO to configure Excel 2013?

Using Excel 2013 (Office 2013, 32-bit, per MS recommendation) on Windows 7 Professional, 64bit in a Server 2008R2 domain. When trying to open an Excel 2013 document, we're getting the error box: ...
user52874's user avatar
  • 829
0 votes
2 answers
4k views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
Justin's user avatar
  • 167
1 vote
1 answer
3k views

How to add a DSQuery script to Excel?

I have to update AD with home users number, etc. I've written the script and imported the usernames and phone numbers into Excel Script: dsquery user -samid "username" "OU=Sys,OU=Prod Services,DC=...
JJJJNR's user avatar
  • 870
2 votes
2 answers
17k views

Shared Excel WorkBook is locked by another user

I’ve been trying everything; this is the last chance I have. I moved folders and files from an old Windows Server 2003 File Server to a new FS (Win Server 2008 R2) with DFS and ABE enabled. Now, a ...
Something's user avatar
  • 105
1 vote
2 answers
10k views

Get full list of host and services from Nagios

I need to get a full list of hosts and services from Nagios, to make a decision table. I think there is two methods, querying the Nagios CGI, and parsing the Nagios cfg files. But... Nagios cfg ...
mvillar's user avatar
  • 438
2 votes
0 answers
1k views

Excel users get error message when opening files located on Windows server

We recently copied all of the shared files for one of our departments from a Sharepoint 2010 document repository to a regular Windows shared folder on a Windows 2008 R2 server. When people try to ...
vrtigo1's user avatar
  • 871
0 votes
1 answer
380 views

Is WSUS 3 .xls export broken?

Trying to get an update analysis report done and the canned reports in WSUS isn't cutting it. When you view a report, you have 2 export options; Excel and PDF. Excel is preferable because I can ...
Chad Harrison's user avatar
0 votes
1 answer
501 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
RTB's user avatar
  • 1
0 votes
1 answer
318 views

How to print/copy the output of a command on IRONPORT

I have to take health checks every day from ironport servers and store some information regarding the server's status at that point of time on a excel sheet. How can I automate this process. I have ...
Nishant's user avatar
  • 101
2 votes
4 answers
10k views

Office 2011, Mac OS Lion, Excel creates temporary file on Windows server 2008, SMB share how to stop?

I have an issue with Macs and a windows SMB share, when using Excel 2011. If I open an excel document from the windows share it will create a "Ghost file" starting with ~$ then the full filename e.g :...
Kevin's user avatar
  • 21
-4 votes
2 answers
4k views

Check a list of passwords strength [closed]

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 ...
user144705's user avatar
0 votes
2 answers
139 views

Troubleshooting server performance with a hosted server?

We are in a tough spot, we have a hosted server with the following specs: OS: Windows Server 2008 R2 Enterprise SP1 64bit Processor: Intel Xeon X7550 @ 2GHz (8 processors) RAM: 16GB The file system ...
ProfessionalAmateur's user avatar
4 votes
1 answer
6k views

Is there any way to prevent Excel 2007/2010 from including .bin files in saved .xlsx files?

In case anyone isn't aware, the new Office 2007/2010 files are actually a type of archive file. Since deploying some recent (ish) Microsoft updates to our client machines, we've been getting lots of ...
HopelessN00b's user avatar
  • 53.9k
15 votes
5 answers
31k views

Install ssconvert (part of gnumeric) on a server without GNOME

I need to use gnumeric's file conversion tool ssconvert on a server. The problem is that gnumeric is a gnome application and can't be installed without a desktop installed. There is also no separate ...
Martin Taleski's user avatar