• 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:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE364,050 pointsBadges:
  • Excel encrypted file support

    How to Excel encrypted file support?

    itajoy25 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:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 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:
  • How to turn off comments field in XLSM file?

    When I use XLSM files in Excel it will open up all the comments fields. This usually happens when I have another excel file open, like an XLXS file too. My usual work around is to close all other excel files and only have the XLSM open. Then it won’t happen. This is a CDT file I need to create...

    Pearlzin055 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Excel shortcut and function keys

    can I use excel shortcut & function keys in formulas. If yes, how.

    Minookv20 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following