• Excel cell referencing across worksheets

    In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003. Any suggestions?

    Ianh5 pointsBadges:
  • Excel Functions

    I am compiling a sales report that with all the sales figures of different branches in my region, these figures are then listed from the best performer to the worst performer in a separate spread sheet using the large function in excell my problem is how do I get the name of the stores to follow...

    Wesleyj5 pointsBadges:
  • One Cell to calc inputs from mult workbooks

    Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.

    BEBGMH5 pointsBadges:
  • 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!

    Scrbayer335 pointsBadges:
  • Can’t change the save option in Word 2007

    In Word 2007's Save Options, I changed the preferred format from .docx to .doc. This works for the session when I make the change. However, if I get out of Word, reboot the machine, etc., the option changes back to .docx. Has anyone else run into this?

    Kkeip20 pointsBadges:
  • 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

    VB Monkey5 pointsBadges:
  • Access 2007 refrence look up

    Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...

    IT-Guy1509210 pointsBadges:
  • formatting excel using lotusscript

    I would like to know how can I draw borders on a cell in excel with lotusscript? I've goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?

    0rland035 pointsBadges:
  • need to push email to PDF from Lotus or Java script without opening document

    Is there a way to export a pdf of a Notes document without opening the document? I want to be able to select a group of docs and run an agent that dumps them to filenames I specify. (iText is not the solution)

    MHanson35 pointsBadges:
  • Header in Word Document using VBA

    How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format

    Idks5 pointsBadges:
  • MS Access Question

    ok im working with office 07, Access. I have multiple checkboxes for one question. I need to create some kind of auto warning system if the user checks more then one box for the same question. I cannot change design because it needs to mimic a current form. As well as needs to have the ability to...

    IT-Guy1509210 pointsBadges:
  • Internet Explorer 6 closes window every time I open a new one

    Hi, Anyone seen this before? Every time I open a new browser window in IE6 running Windows XP Home Edition, the one that's open at the time is closed by the system, so only one browser window can be open at any given time. Regular windows work as they're supposed to I can open as many as I want...

    Xixones0 pointsBadges:
  • access supoort beyond 2007

    will Microsoft package and support Access beyond office 2007

    Richaslam10 pointsBadges:
  • Lotus Notes Import

    I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS Range name: this is...

    Cole5 pointsBadges:
  • How can I display excel and word documents as AS/400 views

    Excel and word documents that reside on our server need to be displayed as AS/400 views/screen displays. How can this be done?

    Manyquestions65 pointsBadges:
  • simple remote administration

    hey y'all... is there a way to do the following remotely? change passwords create a share on a server hard drive I have the adminpak installed on my workstation which allows me to do it. I want to be able to do it from ANY computer on the network. I have Win2k3 servers only, and WinXP clients only....

    TheVyrys0 pointsBadges:
  • Exchange mailbox be backed-up

    Can an individual exchange mailbox be backed-up using the in-built Windows 2000 server backup utility?

    1111100 pointsBadges:
  • How do I activate specific worksheets when importing from Excel

    I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs. Currently I am using this method and it directs to the last saved(active) sheet. Set xlsSheet = xlsWorkBook.ActiveSheet I tired this method but...

    Lespaulcustom0 pointsBadges:
  • Access 2003 – Filter By Form

    Can anyone help me with the following: I have created a form for filtering. I need to be able to export the filtered data within the form to a new Table or export direct to Excel. Does anyone have any knowledge! Thanks

    JulieSandra15 pointsBadges:
  • locking document

    how to lock a word document so that no one can open view edit that file?is the same possible for other MS programmes also?

    Mkrstar0 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