• Excel limiting access

    I want to be able to give access to a spreadsheet for a certain period of time, or until a specific date. Can this be done, and what is the most effective way?

    AussieNewcastle5 pointsBadges:
  • Embedding Microsoft Excel spreadsheet 2007 into Notes 6.5

    My computer is running Notes 6.5 and Excel 2000. I have a request to display data in Microsoft Excel and for my computer it works fine. But when I try it on a laptop running Vista, Notes 7 & Microsoft 2007 the embedd statement doesn't work. I have it coded as: Set object =...

    Gsplmgc70 pointsBadges:
  • Converting Lotus Approach files to Excel 2007

    I received a Lotus Approach 97 .APR file extension file on a flash drive. I need to import it into Excel (Microsoft Office 2007). I am a beginner with Excel and I need to know the steps required to import the Lotus Approach 97 file on the Flash Drive to Excel. I would appreciate any information or...

    MelanieYarbrough6,345 pointsBadges:
  • Enter key does not get translated when doing a mail merge into word from excel

    We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet. The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens...

    Tskn5 pointsBadges:
  • Filter & sort data tables in excel 2007

    When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn't allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two ranges separately and...

    Helenacvdm5 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could i use? First # is starts with 1  back slash 2400.   2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • excel 2007 chart automation

    hi, I have a code that copy charts from one sheet to another sheet and plot graphs. But when I run multiple instances of excel simultaneously sometimes it copy all graphs and sometimes 2 ,4 or 6 charts. This application is working fine with EXCEL 2003 but with EXCEL 2007 giving above problem....

    Ps777self5 pointsBadges:
  • Excel 2007 Large file issues

    I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

    Excelguy5 pointsBadges:
  • Matching Items in 2 worksheets

    This is probably incredibly basic and has a simple answer - at least I hope it does.  I am using Excel 2007. I have 2 worksheets run from 2 different systems.  The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. ...

    Natoma5 pointsBadges:
  • Problem refreshing excel 2003 ms query using excel 2007

    I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...

    KA5 pointsBadges:
  • Transfer particular pieces of data from Excel into Word over a large number of documents

    Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone's name and address in Microsoft Excel 2007,...

    JeanClaudeWasTaken5 pointsBadges:
  • SQL 2005 SSIS 64 bit EXCEL

    How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?

    Oldmickey65 pointsBadges:
  • Re-linking data source in Word 2007

    I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is...

    Minggggy5 pointsBadges:
  • Macro permission in 2007

    As occurs in Excel 2003, I would like to have a dialogue box prompt me when I open a spdsht regarding whether I want the macros enabled.  I have not found that option yet.  Any suggestions?

    Sfe5 pointsBadges:
  • Linked Workbooks return #VALUE error until linked workbooks are opened

    I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I'd really like to be able to open just one workbook at a time. Is there some setting in Excel 2007...

    Blubudda15 pointsBadges:
  • Opening a file from a program vs. from a folder

    We have a shared folder on our server where we store spreadsheets, documents, etc.  It uses Server 2003 Small Business.  If I search for a file using explorer and try to open it, there is usually a decent amount of lag before it opens.  If I open the program and search to open the file from...

    XENOPHON222,340 pointsBadges:
  • Can data on a second sheet be pulled up by a cell on sheet 1?

    Hi... I work in an Emergency Room, and I'm trying to set up either a formula or macro so that when I'm making the "Call List" for the day I can type out the doctor's name in the "A" column, and in the "C" column of the same row have the phone number for the office automatically populate into that...

    LeviG5 pointsBadges:
  • Add in option to transfer from Iseries to excel2007

    I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.

    Jpnick5 pointsBadges:
  • Is it possible to export gantt chart view to excel 2007 in MOSS 2007?

    Hello All,               Is it possible to export gantt chart view to excel 2007 in MOSS 2007?              Now i am trying to export gantt chart view but i am getting only columns in excel sheet. my requirement is i want gantt chart view with list columns in excel sheet....

    NASE5 pointsBadges:
  • BOM Download To Excel For I&PD Exercise

    Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

    NDIRISH5 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