• Create macro on a shared system that will work on different computer

    How do you create a macro on a shared system that will work on different computers? We have a workbook on our shared drive. It is an Excel 2007 with several tabs with 2 pages each. I need to create a macro that will tell the entire workbook to print double sided when opened on other PCs.

    MotorSafety5 pointsBadges:
  • I can’t open two Excel files at the same time

    I can't open two Excel files at the same time. If one file is opened and try to open another file, the first will close without saving. Please help me. I can make view and arrange file vertical or horizontal to open two file but otherwise I can't. It is xlsx only.

    praise5 pointsBadges:
  • Drag-and-drop function in Microsoft Excel

    In Microsoft Excel, I have to do some manual reordering of rows and copying / pasting will take too long. Is there something like drag-and-drop that I can use? Thanks!

    ITKE982,580 pointsBadges:
  • Change .ods files to read as an Excel file

    How do I change an .ODS file so that I can read it as an Excel file?

    jan1ancaster30 pointsBadges:
  • Group by values in Microsoft Excel

    In Excel, I can't figure out how to 'group by' values. My friend told me to use pivot tables but I'm not sure how to do that. I would also like it on another worksheet too. Thanks for the help.

    ITKE982,580 pointsBadges:
  • Excel “Document not saved” message

    I cannot save my excel spreadsheet because this message comes up every time. I have tried a different name for the workbook several times but I always get the message. I have tried Excel Help but the search for this error message produced nothing. Any suggestions please? Thanks

    JoellaWheeler5 pointsBadges:
  • Mail merge from Excel to print labels

    I have gone through the step by step instructions of a mail merge from excel to print labels. When I print, only one page of labels shows up and prints. The rest of the names that are checkmarked to be included does not come up in view document or prints. Only one page. What am I doing wrong?

    karenryen5 pointsBadges:
  • Microsoft Excel: Get distinct values from a column

    In Excel, I have a column with different values and I need to find out what distinct values are in there. Is there a way to do that? Here's what I came up with in SQL Server: SELECT Distinct(MyColumn) FROM MyTable. Is there something like that?

    ITKE982,580 pointsBadges:
  • How to create an Excel file from C#

    Is there a way I can create a Microsoft Excel spreadsheet with C# without having Excel be installed on the machine that's actually running the code

    ITKE982,580 pointsBadges:
  • Advanced Page Numbering in Word and Excel

    I want consecutive Word pages to have even numbers (2, 4, 6, etc). Same problem with Excel.

    SteveJJ55 pointsBadges:
  • Save an Excel Add-in to a network drive

    I have a MSExcel 2010 workbook which uses a User Defined Function via an Add-in (.xlam file). Although the add-in is saved on a network drive, when I try to load it into my add-in list using the browse in the Add-in Manager, it prompts to copy the add-in to the default path on my harddrive:...

    CBURS5 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Import data from Excel 2007 to iSeries

    How do I import data from Excel to iSeries?

    CHARLESG30 pointsBadges:
  • Copy of Excel workbook that’s password protected

    When I want to open an Excel workbook that's password protected, it keeps wanting to open a "copy of ***" too - I have not changed any properties to these workbooks (*** above is the file name).  Thank you.

    jackief25 pointsBadges:
  • How to open Excel file in scheduled agent with LotusScript

    How do I write scheduled agent with LotusScript which reads Excel file on a Linux server that does not have Excel installed?

    mfrancek5 pointsBadges:
  • A tab on my Excel file is completely blank

    I opened an excel file and one of my tabs is completely blank. I did not hide the data it is just blank. All other tabs are intact.

    spionkop5 pointsBadges:
  • Create formula in Excel

    Can you guys create a next formula in Excel, where if a person is given a number and the have to choose the next highest number above it? Example: Say 12 is your number and out of an array of numbers such as 9, 11, 13, 15, 20, the formula would show the 13 is the next highest number above 12.x

    ShenaLinton5 pointsBadges:
  • Big trouble with importing Excel sheet to SQL Server 2012

    Hi, I have following scenario: Installed SQL Server 2012 on WIN 2012 Server Installed SQL Management Studio Installed Visual Studio 2012 Installed SQL Server Data Tools Installed SQL Server Integration Services Everything is related to Express version. I have a software program running on a SQL...

    dkanthony5 pointsBadges:
  • Power usage efficiency in data center

    Is there an Excel spreadsheet template to calculate PUE in data center?

    Wesley15 pointsBadges:
  • Do you know what could be the reason behind, my computer reboots while creating an Excel Pivot Table?

    I have Windows 7 SP1 (64 Bit) and have Microsoft Office Professsional Plus 2010 (32 Bit). Whenever I am trying to create a Pivot Table in Excel, suddenly my computer reboots. It's giving no error messages. I also work in VMware Horizon View Client 3.0 (Virtual Desktop) and there I am facing no...

    nkapur5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following