A program from the Microsoft Office Suite mainly used for calculations

learn more… | top users | synonyms

0
votes
0answers
22 views

MS Excel error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied [closed]

Hi I am trying to connect to SQL Server on another machine using Data >> Other Source >> SQL Server. I have given IP Address of server in Server Name: and Username and Password. But it is giving ...
-2
votes
0answers
25 views

The file is corrupt… Excel 2010 [closed]

So I spent all last week creating a mega spreadsheet with Excel 2010. The file ended up being quite large with many complex formulas. After saving it to one location I saved it to another hard disk ...
1
vote
3answers
387 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
38 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
103 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
154 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 ...
0
votes
0answers
63 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
232 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
218 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
0answers
33 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
163 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
565 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
1answer
4k 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
278 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
274 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
132 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
172 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
3answers
4k 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
402 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 ...
1
vote
0answers
345 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
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 ...
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
2answers
569 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, ...
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 ...
-1
votes
2answers
4k 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?
7
votes
1answer
5k 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
119 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
3k 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 ...
8
votes
2answers
26k 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 ...
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
vote
1answer
403 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. ...
1
vote
2answers
142 views

best way to host publicly editable documents on intranet with direct saving

I am currently in the process of developing an apache based intranet for our company, to replace the current network folder based system. The current system works well, in that as the documents that ...
0
votes
2answers
314 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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
0
votes
1answer
813 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 ...
0
votes
2answers
4k 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
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 ...
1
vote
1answer
193 views

AD yearly update program

So here's the problem, I'm considered a technician, due to there already being an on-site senior technician, however he has no scripting/programming ability. I have a little, but most of it has faded ...
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 ...
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 ...
1
vote
3answers
1k views

Excel 2003 Shared Document Freezes

We have a few users who are sharing a rather large excel file (70 megs) via a network drive. If they save the file after each tiny modification, then there are no problems. But if they try to do a ...
2
votes
2answers
507 views

Finding an Excel spreadsheet to plan GPO deployment

My boss gave me a spreadsheet that he says he found from MSFT somewhere. The problem is the spreadsheet is for 2003 GPOs and I need to find one for 2008. The spreadsheet lists all of the available ...
1
vote
0answers
1k views

Excel techniques for perfmon csv log file analysis

I have perfmon running against several servers, where I'm outputting to a .csv file data like CPU %time, memory bytes free, hard disk I/O metrics like s/write and writes/s. The ones graphing the SQL ...