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

83 questions
14
votes
5 answers

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 packages for ssconvert, and I can not compile it…
Martin Taleski
  • 363
  • 3
  • 5
  • 14
9
votes
1 answer

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 processes that use code (Office Automation) to open…
Glen Little
  • 435
  • 2
  • 7
  • 17
9
votes
2 answers

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 another user tries to open the file, Excel gives…
ScottStonehouse
  • 979
  • 4
  • 16
  • 25
7
votes
2 answers

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 password-protected excel spreadsheets. Before I…
l0c0b0x
  • 11,697
  • 6
  • 46
  • 76
4
votes
3 answers

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 same result. However, I can't consistently create…
michaelf
  • 141
  • 1
  • 1
  • 2
4
votes
9 answers

Convert a CSV file to a XLS file on the linux command line?

I'm using Debian Linux and I want to convert a CSV file to an Excel XLS Spreadsheet file. The catdoc package includes the xls2csv command that converts from XLS to CSV. However it doesn't do the reverse. Since I just have a CSV file, I don't care…
Amandasaurus
  • 30,211
  • 62
  • 184
  • 246
4
votes
1 answer

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 reports of blocked and quarantined outbound emails…
HopelessN00b
  • 53,385
  • 32
  • 133
  • 208
4
votes
2 answers

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 has only started occurring since we have setup…
Kiwi
  • 41
  • 1
  • 4
4
votes
2 answers

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

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. With two specific I mean that I first got 26000+…
Ernst
  • 41
  • 1
  • 2
4
votes
4 answers

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 columns' wizard with 'spaces' and 'brackets' as…
adolf garlic
  • 171
  • 1
  • 1
  • 8
4
votes
5 answers

Excel file growing huge (>150 MB)

There is one particular Excel file that is used by a number of employees at my company. It is edited from both Excel 2003 and 2007, with the "Sharing" feature turned on to allow multiple writers at once. The file has a decent amount of data on…
Josh
  • 743
  • 4
  • 9
  • 17
3
votes
1 answer

Do WebDAV mapped drives work similar as network mapped drives

I'm trying to share an Excel 2007 Workbook with Sharing capability. I already tried sharing it over the network from my computer and it worked perfectly. Multiple users were able to open/edit/save it at the same time. Excel took care of merging the…
Robert Koritnik
  • 912
  • 5
  • 19
  • 34
3
votes
3 answers

Excel file always opens in Read-Only mode over WebDAV

I mapped a WebDAV drive in my Windows Explorer. I can access files and browse etc. But. When I try to open my Excel file it always opens in Read-only mode. How do I open a file so it opens with write permissions? I'm sure no-one else is working on…
Robert Koritnik
  • 912
  • 5
  • 19
  • 34
3
votes
1 answer

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, "Unable to process request. Wait a few minutes and…
BenC
  • 751
  • 1
  • 9
  • 24
3
votes
5 answers

Opening an Excel spread sheet in .NET on a x64 system

I can't open an Excel spread sheet with .NET on an x64 server using the following connection string "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filePath + "; Extended Properties=Excel 8.0;" I get The 'Microsoft.Jet.OLEDB.4.0' provider is not…
Bob The Janitor
  • 163
  • 2
  • 7
1
2 3 4 5 6