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
1
vote
0 answers

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 this morning and connected to a server so I could…
WakeDemons3
  • 185
  • 6
1
vote
0 answers

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 problem: User1 opens an Excel file either from…
Mikael Dyreborg Hansen
  • 559
  • 1
  • 5
  • 16
1
vote
0 answers

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 config file for the share. [SHARENAME] force create…
Niel Buys
  • 11
  • 3
1
vote
0 answers

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 Templates -> MS Office 2013 -> Security Settings -> Trust…
Travis
  • 870
  • 8
  • 23
1
vote
1 answer

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 automatically relinks these files. However, it…
Jonathan Nelson
  • 11
  • 3
1
vote
1 answer

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 Tabular Model's role-based perspectives we need to pass…
Édgar Sánchez Gordón
  • 111
  • 2
1
vote
2 answers

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 workstation (Office 2013, Windows 8.1). Is there any way of…
Dam
  • 11
  • 2
1
vote
5 answers

Subnet calculator for MS Excel

I quite often use the handy subnet calculator here: http://www.subnet-calculator.com/ Which I find very useful. However, does anyone have details/a link for a version of this that offers similar functionality but is in an excel spreadsheet. I could…
Martin
  • 572
  • 4
  • 14
  • 26
1
vote
0 answers

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 that VM. Standard users will only have access…
Bill Vallance
  • 227
  • 2
  • 8
1
vote
3 answers

Nothing happens when using "Edit in Microsoft Excel" button in Sharepoint

The user is trying to edit a sharepoint document. It works on every other computer, just not on this particular one. All computers are running IE and Office. I'm used to seeing the "This document is locked out to.." error, but in this case nothing…
me_here
1
vote
4 answers

How to read cell data in excel and output to command prompt

I'm a sys admin and I am trying to learn how to use powershell... I have never done any type of scripting or coding before and I have been teaching myself online by learning from the technet script centre and online forums. What I am trying to…
Max Ollerenshaw
  • 31
  • 1
  • 1
  • 3
1
vote
2 answers

sharepoint cannot export all fields to spreadsheet

I am trying to make an export of a list in SharePoint to an Excel spreadsheet. I have added all needed fields to my default view of the list, (like Publishing Start Date / End date) but some fields (like Publishing Start Date / End date) don't show…
Colin Dekker
  • 415
  • 4
  • 12
1
vote
1 answer

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=win,DC=ite,DC=com" | dsmod user -mobile "999"…
JJJJNR
  • 870
  • 6
  • 20
  • 32
1
vote
2 answers

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 files may not be standard and this could be a…
mvillar
  • 438
  • 1
  • 7
  • 19
1
vote
1 answer

How do I open an event viewer file in Excel 2007

I have an event view that I need to filter and pivot the data from. I tried exporting the file as a CSV file, but that is missing the description. I tried exporting the file as XML, but there was no schema, so excel opened it as a table and it was…
Rob White
  • 463
  • 8
  • 16
1 2
3
4 5 6