A program from the Microsoft Office Suite mainly used for calculations

learn more… | top users | synonyms

1
vote
1answer
2k views

Why Are Excel 2010 Files Locked By Logged-Off Or Account-Disabled Users

I manage IT for a medium sized company that shares a lot of Excel 2010 files between users at various times of the day. We're using a Terminal Server environment (S2008R2). Sometimes, a user will ...
8
votes
2answers
27k 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 ...
1
vote
7answers
22k views

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 ...
1
vote
3answers
665 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
45 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 ...
0
votes
1answer
177 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
172 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
4answers
16k views

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 ...
0
votes
0answers
74 views

Legacy files, opened in Excel 2010, have missing/hidden data

We've got a client who has 1,000's of excel documents that were created in Excel 2000 (or earlier). Which they still use to this day (Currently on Excel 2010) A few users are experiencing issue with ...
0
votes
2answers
348 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
267 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: ...
1
vote
1answer
5k 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 ...
0
votes
0answers
37 views

Sharepoint checked out documents cross reference issue

After a rebuild of a Win 7 Ent Laptop, a user has reported that they can no longer cross reference documents that have been checked out from a sharepoint 2007 environment. They are adamant that they ...
0
votes
1answer
4k views

“An error has occurred” when opening xlsx files on Sharepoint 2010

We just recently installed and have been using SharePoint 2010 and have run into a bit of a problem opening Excel spreadsheets with the xlsx extension. We are able to upload a spreadsheet with the ...
0
votes
2answers
5k views

When ran as a scheduled task, cannot save an Excel workbook when using Excel.Application COM object in PowerShell

I'm having an issue where I've automated creating an Excel.Application COM object, add some data into a workbook, and then saving the document as an xlsx. This works fine if: I'm already in ...
0
votes
1answer
188 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 ...
0
votes
1answer
612 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 ...
1
vote
2answers
322 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 ...
4
votes
2answers
2k 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
0answers
293 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
2answers
702 views

Publishing an Excel spreadsheet using Microsoft SBS 2008 to a web page that is viewable by mobile phones (not necessarily smart phones) [closed]

I am getting well out of my “superuser” depth here and would love some support. At work we have an Excel workbook (*.xls format circa Office 2003) which maintains our “engineers” timesheet. This ...
1
vote
3answers
2k views

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 ...
0
votes
1answer
144 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 ...
1
vote
2answers
2k views

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 ...
3
votes
5answers
1k views

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 ...
0
votes
1answer
200 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 ...
1
vote
2answers
284 views

Excel 2010, SQL Server & PowerPivot Add-On - Anyone have feedback?

We're in the process of developing a SQL Server reporting model that integrates with the new Excel 2010. Questions: Has anyone used the new Power Pivot addon? What's your experience been like with ...
2
votes
0answers
1k views

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 ...
-1
votes
2answers
5k 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?
1
vote
2answers
2k 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 ...
1
vote
3answers
5k 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 ...
0
votes
5answers
2k views

Hiding SQL Server 2005 system objects/schemas from Microsoft Query

End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering ...
-4
votes
2answers
429 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 ...
2
votes
1answer
2k 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 ...
1
vote
0answers
349 views

Installation of Access Database Engine 32-bit Fails

I am trying to install Access Database Engine 2007 32-bit. The splash screen comes up, you click "Next", then it fails with the error: Installation ended prematurely because of an error You click ...
0
votes
2answers
108 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 ...
2
votes
2answers
593 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 ...
3
votes
1answer
3k 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, ...
0
votes
1answer
2k views

Exporting XML Spreadsheet as XML data from Mac Microsoft Excel 2011

I want to use an XML file to facilitate data imports into an Oracle APEX application. The primary reason why I want to use XML is that some of the fields in the Excel spreadsheet could contain many ...
3
votes
1answer
1k 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 ...
7
votes
1answer
6k 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
2k 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
122 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 ...
6
votes
2answers
4k 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 ...
1
vote
1answer
410 views

Deploy an Excel spreadsheet which uses the solver on both 32bit and 64 bit installations [closed]

I have an Excel spreadsheet which uses the solver add-in. I've developed it on a Windows 7 64 bit machine. The spreadsheet relies on some VBA code to set up the solver so I need a reference to solver. ...
3
votes
1answer
4k 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 ...
0
votes
2answers
319 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 ...
1
vote
1answer
1k 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
1answer
1k views

Why Does Excel 2010 Leave A Trail Of TMP Files?

I am losing hard drive space because of some deep, dark phenomenon being caused by Excel 2010. It seems like every time a user opens or closes a file, or maybe if Excel crashes (I haven't figured out ...
0
votes
1answer
835 views

ADO Library Reference in Office Application between x86 and x64

I'm running Office 2003 (specifically Excel) on both a Windows XP 32-bit OS and Windows 7 64-bit OS. I have an excel file in which is referenced: "microsoft ado ext. 2.8 for dll and security". When ...