Excel 2007

Excel 2007 data - sorting source workbook

I want to create a link to data in a second workbook. My problem is when the source workbook is sorted, the links are misaligned. I don't think absolute/relative references are the issue. How do I create a link such that no matter where external reference in the source workbook workbook moves...

Excel data daily update linking between workbooks

Using Excel, I am trying to link a column in one workbook to update daily to one cell in another workbook. The part I can not get to work is making the one cell automatically pull the current date value from the first workbook. I believe I need to use either an IF formula or a macro to tell the...

Issues with Microsoft Office 2007

OS: Vista Home Premium Here's a list of the issues I'm experiencing - very strange behavior. 1. When I try to open a .doc or .docx file from Windows explorer, word opens up, but doesn't display the document - just the grey default screen. When I open up word, and then open a file up from there,...

Rusty and Need Help

I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

How do I run Excel Reports?

Is is possible to run reports similar to how you run reports in Access in Excel 2007?? If so, How?

Excel 2007 - allocating non-repeatable values in a set

I am creating a questionnaire. There is a set of 4 words and users are asked to rate each word with a value from 1 to 4. The user can not repeat any of the values between the 4 words in one set. There are many sets of 4 words and as a result, this process has to be repeated many times. I am...

Excel 2007 freeze pane problem

Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed

Excel 2007 Freeze pane problem

AOA SIR, I am using Office 2007. I have protected sheet which were created in office 2003. When ever we have open this proted Workbook In Excel 2007 the freeze pane option is disbaled. Please help me out to Solve the Above mention Issue. I Will thankfull to You.

Excel 2007 Macros problem

AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.

Problem in Data Downlod from SAP to Msoffice 2007

Problem in Data Downlod from SAP to Msoffice 2007. If i use data export option from SAP to Excel 2007 a blank xls sheet open but no SAP data apear in sheet.

CSV data into Excel 2007

Here's the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each "chr" value into it represented ascii equivalent. Example: chr(58) is a...

combo box in microsoft excel

How do i link numeric values to word choices in my combo box? i have tried If Then's for if you pick a certain choice it = a certain number, but im stuck! thanks

MySAP to excel 2007

We just upgraded to excel 2007. When I try to export a spreadsheet from MYSAP to Excel, the worksheet comes up blank and no information can be seen. Any help would be appreciated!

Automate download from ALV grid to excel using VBA

I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks

transferring data from iSeries to Excel 2007

Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?