Microsoft Excel Questions


Access denied message when trying to save on network
Hi all I have Server 2003 operating system om server.and officeXp with Office2007 on desktop when I work some EXCEL work on Desktop and treid to save on server it give me “Acces denied” Is Anybody Have any sloustion for thant.pls help me to reslove the issue.thanks in advance.

Answer Question   |  December 14, 2009  10:40 AM
Microsoft Excel, Office 2007, Windows Server 2003, Windows Server Error Messages
asked by:
70 pts.

Can I find an Excel merged cell size in VBScript?
I have a set of Excel spreadsheets which all have similar properties and I’m trying to automate a set of processes on them. I’m a compelte VB beginner, but it’s going ok – I’ve just hit a stumbling block with the internet isn’t being very helpful with. Once I have found a certain cell, is [...]

Answer Question   |  December 11, 2009  11:12 AM
Microsoft Excel, VBScript
asked by:
15 pts.

Excel 2007 – gauge, speedometer, or dial charts….
Hi, Does anyone have any idea were i could find some some sample templates on these 3 for : Excel 2007 – gauge, speedometer, or dial charts…. Thx Jared~

Answer Question   |  May 13, 2010  8:22 PM
Excel 2007, Microsoft Excel
asked by:
185 pts.

Automatically Transfering from Excel to iSeries
I see there is a Transfer Data to iSeries option but is there a way of making this run automatically daily? Can something be schedulled from iSeries to initiate that? I want to reduce user intervention so would prefer not forcing the user to daily execute the upload. Any suggestions? Thanks, Rod

Answer Question   |  March 24, 2010  5:13 PM
Excel to iSeries, Microsoft Excel
asked by:
20 pts.

Is it possible to export gantt chart view to excel 2007 in MOSS 2007?
Hello All,               Is it possible to export gantt chart view to excel 2007 in MOSS 2007?              Now i am trying to export gantt chart view but i am getting only columns in excel sheet. my requirement is i want gantt chart view with list columns in excel sheet. Please provide some inputs .. [...]

Answer Question   |  November 17, 2009  12:47 PM
Excel 2007, Microsoft Excel, Microsoft SharePoint, MOSS 2007, SharePoint 2007
asked by:
5 pts.

BOM Download To Excel For I&PD Exercise
Are there easy directions for me to download from the SAP BOM’s comprising 7000 lines to Excel for manipulation and pivoting of the data?

Answer Question   |  November 13, 2009  1:12 PM
Excel 2007, Microsoft Excel, SAP BOM, SAP to Excel
asked by:
5 pts.

How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?
I am recreating a transfer form we currently have on paper into an Excel spreadsheet to have it electronically emailed. In the form I have a section that asks the user to choose a desired station to transfer to from a list of 3 stations with check boxes next to each station. I would like to [...]

Answer Question   |  November 9, 2009  4:36 PM
Excel Forms, Microsoft Excel
asked by:
5 pts.

Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i
Is it possible to restrict running of NASTIE (Now a simple tool in Excel) on system i

Answer Question   |  November 6, 2009  1:31 PM
AS/400 administration, AS/400 Restricted State, Microsoft Excel, NASTIE
asked by:
1,160 pts.

How to export excel data to Sql server 2005
How to export excel data to Sql server 2005

Answer Question   |  August 10, 2010  11:04 AM
Excel 2007, Exporting Excel to SQL, Microsoft Excel, SQL Server 2005
asked by:
5 pts.

Converting SQL 7 Database to Excel
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

Answer Question   |  November 4, 2009  7:37 AM
Microsoft Excel, SQL, SQL 7, SQL to Excel Database Conversion
asked by:
40 pts.

Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows
I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date [...]

Answer Question   |  October 9, 2009  9:09 PM
AS/400 - DDS, AS/400 data transfer, DDS, DDS Server, Excel 2007, Excel to iSeries, Exporting AS/400 to Excel, Microsoft Excel
asked by:
35 pts.

SQL 2008 Security: How do I give users access to just views within a DB?
[h1 class="subject"> [/h1] I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the [...]

Answer Question   |  October 3, 2009  5:19 PM
Microsoft Excel, SQL, SQL 2008
asked by:
5 pts.

Download Spool file to Excel Format
Hi Guys, Do you have any idea how to download the Spool Files(WRKSPLF with PRTF) to Microsoft Excel?   Thanks Mickey

Answer Question   |  November 15, 2009  3:24 PM
iSeries, Microsoft Excel, Spool files
asked by:
20 pts.

Import GPO XML report to Excel
I am trying to find a way to Import GPO XML reports into Excel for comparison. I am unable to figure an easy way to convert the files to rows and columns

Answer Question   |  August 31, 2009  7:43 PM
GPO, Microsoft Excel, XML
asked by:
5 pts.

Sharing Problems in Excel
We have several spreadsheets that we share with 5 users. Some of these worksheets seem to grow to a large size in a short amount of time, even though they actually don’t contain that much information. These are files that several people are updating and viewing many times per day. For example, I had a [...]

Answer Question   |  August 25, 2009  4:50 PM
File Shares, Microsoft Excel, Microsoft Office 2007
asked by:
5 pts.

Outlook 2003: Export PST Emails To Excel
When I use the “File > Import & Export” command from Outlook 2003, I have mixed results. I keep my emails in sub-folders off one of several PST files that I use regularly, in the “All Mail Folders” side-panel. I broke up the larger folders into smaller ones in case there was a size limitation. [...]

Answer Question   |  November 30, 2009  11:34 PM
.PST files, Excel 2003, Export PST, Microsoft Excel, Outlook 2003, Windows XP, Windows XP Professional, Windows XP Professional SP2
asked by:
5 pts.

Arabic Text In AS/400 to Excel
Arabic Text when transfered to from AS400 to Excel displays garbage. Is there an add in I need to install?

Answer Question   |  August 19, 2009  3:31 PM
AS/400 Languages, Exporting AS/400 to Excel, Microsoft Excel
asked by:
5 pts.

Working with Login Userforms
I’ve been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs “password”, receives an invalid password message, then reenters their password.) As the code [...]

Answer Question   |  August 21, 2009  8:52 PM
Excel 2003, Microsoft Excel, VBA
asked by:
255 pts.

How can I import data to mainframe from Excel in REXX
I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset

Answer Question   |  August 13, 2009  11:43 AM
Microsoft Excel, REXX, REXX Mainframe
asked by:
5 pts.

OFFICE XP ERROR MESSAGE
Dear friends I have one system that should member of Domain I am all ready installed the Office 2003 applacition in Domain But after installing the applation whin i oppen the file I am getting erroe message Microsoft excel has not been installed for the current user plz run setup to install the applation. What [...]

Answer Question   |  August 8, 2009  7:10 AM
Microsoft Excel, Microsoft Office, Microsoft Office Error Messages, Office 2003
asked by:
15 pts.