• 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:
  • Microsoft Excel: Next Status Change

    I have a two tables. On table has a unique order number and the associated time it entered a production stage (status). I have another table which has the unique order number and time stamp for each time a production stage changed (status). On the first table how can I systematically determine the...

    mtrial5 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:
  • Exporting Contacts in Outlook 2007 in an Excel Spreadsheet

    I just tried to export my contacts into an excel spreadsheet. I followed the instructions but when it imported, all it imported was the title line, you know first last title company email website phone fax cell address city state zip. However NONE of that information imported over. None. What do I...

    Diva535 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Microsoft Excel: Accumulative sum for 12 month period

    How can I add accumulative sum for 12 month started from JAN to DEC. If data in JAN is zero, then accumulative sum from FEB to JAN. If data in FEB is zero, then accumulative sum from MAR to FEB and so.

    NavinSinha19665 pointsBadges:
  • Is there a better way for material requisition from warehouse to production?

    Hi SAP expert, Now my company is using a somewhat old fashioned way for MR (material requisition) which is as per below steps: Prod raise MR using email (excel format) Warehouse receive email and check stock through LS24 Warehouse pick pack and PGI via MB1A or MB1B Is there any better way to use...

    philip574910 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • Windows 7 cannot open Excel file

    I'm the Information Technologist for a manufacturing company and have a Dell workstation running 32-bit Windows 7 and MS Office 2007. When the user attempts to open a particular Excel file, Excel complains that the file is corrupted. Yet other employees running Excel 2007 under either Windows XP or...

    johnjam2325 pointsBadges:
  • Convert report to Microsoft Excel

    I used ole2 to convert report to Excel but Arabic fonts appear in the form :ÚÈÏÇáÑÍãä ÚÈÏÇááå ÇáÕäÚÇäí 5*967. How I can solve this problem?

    jabbary15 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51185 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