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).
90
questions
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 ...
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 ...
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 ...
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: ...
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 ...
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()
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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-...
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 ...
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 ...
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 ...
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
$...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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: ...
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 ...
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=...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 :...
-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 ...
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 ...
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 ...
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 ...