Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [microsoft-excel]

A program from the Microsoft Office Suite mainly used for calculations

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

Excel Add-ins are not showing in the latest office, how to fix that?

With 1803 OS Build of windows 10 and office version below 136104-image.png Here, after I install my add-in using the msi provided by vendor, it is showing in the excel toolbar. office version 1803 But ...
user avatar
1 vote
1 answer
163 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 ...
user avatar
0 votes
1 answer
268 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 ...
user avatar
0 votes
1 answer
47 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 ...
user avatar
1 vote
1 answer
942 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 ...
user avatar
  • 121
0 votes
1 answer
191 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 ...
user avatar
0 votes
1 answer
125 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. ...
user avatar
2 votes
2 answers
4k 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 ...
user avatar
0 votes
1 answer
64 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 ...
user avatar
4 votes
3 answers
27k 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 ...
user avatar
  • 141
1 vote
0 answers
49 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 ...
user avatar
1 vote
0 answers
330 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 ...
user avatar
1 vote
0 answers
1k 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 ...
user avatar
0 votes
1 answer
124 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-...
user avatar
1 vote
0 answers
348 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 ...
user avatar
  • 870
0 votes
0 answers
50 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 ...
user avatar
  • 223
1 vote
1 answer
857 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 ...
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 $...
user avatar
  • 1
0 votes
1 answer
3k 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 ...
user avatar
1 vote
1 answer
371 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 ...
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 ...
user avatar
  • 11
1 vote
0 answers
193 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 ...
user avatar
0 votes
1 answer
44 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 ...
user avatar
  • 101
2 votes
3 answers
16k 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 ...
user avatar
  • 21
0 votes
1 answer
147 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 ...
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 ...
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 ...
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 ...
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: ...
user avatar
  • 819
0 votes
2 answers
3k 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 ...
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=...
user avatar
  • 860
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 ...
user avatar
  • 105
1 vote
2 answers
9k 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 ...
user avatar
  • 428
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 ...
user avatar
  • 861
0 votes
1 answer
376 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 ...
user avatar
0 votes
1 answer
478 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 ...
user avatar
  • 1
0 votes
1 answer
308 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 ...
user avatar
  • 101
2 votes
3 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 :...
user avatar
  • 21
-4 votes
2 answers
3k 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 ...
user avatar
0 votes
2 answers
135 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 ...
user avatar
4 votes
1 answer
5k 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 ...
user avatar
  • 53.2k
13 votes
5 answers
26k 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 ...
user avatar
2 votes
2 answers
1k views

Pushing Information into a Networked/Shared Read-Only Excel File Used by Multiple People [closed]

We have a pretty unique situation at work. We have order takers who take orders and each individual references the same shared read-only excel document on a network storage drive. This excel document ...
user avatar
0 votes
2 answers
4k views

What could slow Excel on one PC but not another?

I have 2 PC with the same configuration. I open an Excel File (~5M) on the network from both PC. The opening is not the fastest but that's ok. The problem is that on one PC, Excel is really slow. I ...
user avatar
  • 143
3 votes
1 answer
5k views

Excel web view broken in SharePoint 2010

Last night I patched and rebooted our SharePoint 2010 server. Everything looked fine but this morning the Excel web viewer is broken. When trying to open a spreadsheet I get an error box stating, "...
user avatar
  • 751
4 votes
2 answers
3k views

Corrupt Excel Files After Setting Up User Profiles, Folder Redirection & Offline Files

We have a bunch of excel files that are at random becoming corrupt. The error message is excel has found unreadable content... I believe this question is relevant to serverfault because the problem ...
user avatar
  • 41
0 votes
2 answers
19k views

How to open Office documents in Browser [closed]

I have an intranet where I want to configure all Excel/Word documents to open in the browser window. How do I change this setting for all users?
user avatar
  • 183
9 votes
1 answer
15k views

Can I run Excel 2010 on a server?

This question is not about a person using Excel on a computer that happens to have an Windows Server OS. And it is not about using any Sharepoint services features! The question is about automated ...
user avatar
0 votes
2 answers
6k views

Local Save in Excel with iManage add-in

Using iManage (AKA Filesite, Worksite) 8.5 and Excel 2007. Having trouble saving documents locally. Saving into iManage works fine, but trying to export documents to a local directory using 'local ...
user avatar
  • 912
1 vote
1 answer
234 views

Remove Excel Add-In program installed by user from other windows account

I developed an add-in for excel and the first version I send an email with the .exe file to users install (The system center was not working at that moment). Now I need to uninstall the add-in (from ...
user avatar
  • 111