Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel]

A program from the Microsoft Office Suite mainly used for calculations

0
votes
0answers
5 views

How to solve time delay issues in excel file due to hidden names [migrated]

I found a weird problem with one of excel file i received. Its only small size file like 300 KB. But it is taking time to move from one cell to another after entering the data in a particular sheet ...
1
vote
1answer
702 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
0answers
43 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 ...
0
votes
0answers
19 views

Excel Power Query (aka Get and Transform) from SSAS 10x slower after version change

I have been using Excel Data Get and Transform (i.e. Power Query) for some time to query data from our data warehouse Excel BI server using the SSAS wizard. A number of such queries that pulled more ...
1
vote
0answers
92 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
0answers
480 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
1answer
91 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
0answers
197 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
0answers
44 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
1answer
373 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
2answers
882 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
1answer
2k 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
1answer
290 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
1answer
454 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
0answers
183 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
1answer
40 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
3answers
11k 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
1answer
144 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
2answers
3k 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
1answer
1k 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
2answers
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
1answer
3k 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
2answers
2k 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
1answer
2k 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
2answers
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
2answers
7k 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
0answers
861 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
1answer
333 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
1answer
427 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
1answer
302 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
3answers
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
2answers
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 ...
0
votes
2answers
126 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 ...
3
votes
1answer
4k 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 ...
9
votes
4answers
15k 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 ...
2
votes
2answers
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 ...
0
votes
2answers
3k 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 ...
3
votes
1answer
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, "...
4
votes
2answers
2k 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 ...
0
votes
2answers
17k 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?
9
votes
1answer
14k 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 ...
0
votes
2answers
5k 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 ...
1
vote
1answer
225 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 ...
7
votes
2answers
5k views

Are there huge drawbacks to using an excel 2010 document for password management?

At my old job, we used an open-source, (IMO) secure method for managing network infrastructure, and other important hosts' passwords [with Keepass]. At my new job however, it seems like they're using ...
9
votes
2answers
67k views

When an Excel file is locked on a network share, how does it know who locked the file?

We are using Excel 2010 and sometimes users are working from a network share. When a user on the network opens the file in Excel, the file is locked for editing - this is the expected behavior. When ...
4
votes
2answers
3k views

Weird bug when copying from sql server management studio to excel in windows 7 [closed]

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in Excel....
0
votes
2answers
453 views

I have a KMS/MAC key for Excel 2010, where can I download the media? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I need to get the stand alone version of Excel 2010 installed on a server. I have the KMS/MAC key for it but I can't find ...
3
votes
1answer
7k views

Slow opening of Excel files on the network

This week, we had an issue with Excel files opening slowly on the network. Some, despite being only 21K over 1000BT, took as much as 5 minutes to open. They opened fine locally. Someone beat me to ...
1
vote
1answer
2k views

Excel Macro : Run-time error '1004' General Mail Failure

We are planning to upgrade all our users to Outlook 2010 and Exchange 2010 soon but have run into a few headaches with the Outlook migration. We have an Excel spreadsheet that is basically an expense ...
2
votes
3answers
10k views

Results copied from SSMS splitting across columns when pasted into Excel

SSMS 2008 -> Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to ...