Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Excel question
- In an excel file, i have 2 worksheets called "A" and "B". "A" has a load of data on the sheet with a filter turned on. B is a blank worksheet. In "A" i filter it down for things that happened between 2 dates, say >10-1-06 and <...
- Tags: Excel Question, COUNTIF, Range, Ronan.Anglin@..., software, Microsoft Excel
- Q&A 2006-04-27
- Excel Question
- Hi --If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like "BLANK CELL FOUND", then how do I do this?...
- Tags: B2:E2, BLANK CELL FOUND, cell, Excel Question, johnshenyang@..., Microsoft Excel
- Q&A 2005-10-14
Additional Resources
- Opening Multiple Copies of Excel in VBA
- This probably sounds an incredibly stupid question, but I have been asked to develop an app for a client that uses Excel but is not to behave like Excel. I've gone through the process of removing the menu and toolbars etc, but I want to be able to open...
- Tags: Microsoft Office, VBA, dean.crawley@..., Microsoft Excel
- Discussion threads 2007-07-18
- Unable to link documents in Excel 2000
- Hi,I have a user who is opening an existing excel document, then trying to link another excel document to a field. However, when they do this, it throws up "Excel.exe has generated errors and will be closed by windows. You will need to restart the program"My first question is:...
- Tags: andeb1uk@..., Microsoft Excel
- Discussion threads 2007-05-23
- Question on an Excel file
- I have an Excel file from others. When trying to open it in Excel 2003, it prompts that "This workbook contains links to other data sources. If you update the links, Excel attempts to retrieve the latest data; if you don’t update, Excel uses the previous information". But no matter...
- Tags: Excel 2003, hunter_jn_cn@..., Microsoft Excel, software
- Q&A 2006-09-05
- Need FormMail output TO Excel solution (Mac OS X platform)
- Hello all -A client has asked if FormMail results (an email with data presented as "question: answer") could be imported into an Excel worksheet via an automated process.Ideally, the process would gather all submitted emails via FormMail located in a folder have their data dumped into an Excel file (given...
- Tags: Microsoft Office, Apple Macintosh, Apple Mac OS, sabrinus@..., Apple Mac OS X, Need FormMail, Microsoft Excel
- Discussion threads 2007-04-13
- how can i creat macro in excel
- blog roothow can i creat a macro in excelcan any body guide me how to creat macro in excel step-by-stephow can i creat a macro in excelno i can't help u specifically. I use Excel but ain't an Excel expert. I created a macro once. It wasn't difiicult, if i...
- Tags: Microsoft Office, itsitguy@..., Microsoft Excel
- Discussion threads 2005-08-09
- Excel 2003
- How do I restore the missing "File, Edit, View" menu in Excel?assuming all other toolbars are removed also...start->run-> "C:Program FilesMicrosoft OfficeOFFICE11EXCEL.EXE" /aClose Excel.Search in your profile for *.xlb.Delete the file.Restart Excel.This will revert Excel's menus and Toolbars back to default. Poster rated...
- Tags: Microsoft Office, Microsoft Excel
- Q&A 2006-01-11
- How to read an Excel file without opening the file
- Hi,I would like to know how to read a set of data in an Excel file, either with the PC or via LAN, without opening the Excel file using Excel VBA programming.No writing is required.Next question: Is it possible to write a data into Excel file without opening the file?Please...
- Tags: Excel File, Microsoft Excel, tallman_roy@...
- Discussion threads 2007-01-28
- MS Project to Excel, Excel to PowerPoint
- Just got assigned a new project and want to know if this is even possible. I need to import data from MS Project to Excel then export data from Excel to PowerPoint; all using a VBA macro.In MS Project make your Excel file an external table and write to it...
- Tags: Microsoft Corp., Microsoft Excel, Microsoft PowerPoint, Microsoft Project, programming, stindle@...
- Q&A 2005-11-29
- Replacing Wildcards in MS Excel
- Hi all!I was trying to replace the character "*" in MS Excel. The "traditional" way does not work (write * in the Replace box).Does anybody know how to replace a wildcard in Excel?I found a way (change the file to .txt, make a find and replace and then go back...
- Tags: Microsoft Office, Microsoft Corp., rayasta@..., Microsoft Excel
- Discussion threads 2007-03-19
- Excel
- I posted a question in the wrong forum. can you refer to "using excel to store data automatically" please?
- Tags: Microsoft Office, jphillips@..., Microsoft Excel
- Discussion threads 2007-04-06
- Test if an excel file contains macro
- I want to check the .xls files in our network to see who uses macro in excel. Is it a way to check an excel file for macro in a scripting environment ?I would try looking at "ActiveWorkbook.VBProject" and it's associated properties.This is working but... As I wanted to run...
- Tags: File servers, macro, This IS
- Q&A 2006-08-07
- Excel 2003 Last User
- Hey guys,I need a formula that will show what user last edited a workbook and at what time he/she did this. I know it will have to be a shared workbook but beyond that I'm clueless. Excuse me, kind of new to formulas here.Second question: What books do you guys...
- Tags: Excel 2003, Ken G., Microsoft Excel, software
- Q&A 2005-04-11
- Open Access Qry in Excel Cmd Button
- I have an Access form from which I need to open a different Query in Excel. How do you do that?I know how to open tables, queries, spreadsheets or documents with a command button, but how do you open a query in excel the way you can with the...
- Tags: Microsoft Office, Databases, Microsoft Excel, Microsoft Access
- Q&A 2006-02-28
- Excel Links in IE6
- Has anyone seen this. When I setup a link from a web page that targets an excel spreadsheet, when this link opens (within IE6) the toolsbars do not show. By click on view, toolbars and select the ones that I want I can work away. However, if...
- Tags: Microsoft Excel, Microsoft Internet Explorer, Microsoft Internet Explorer 6, software, stephen.cranfield@..., toolbar
- Q&A 2005-11-02
- Excel file's generating "pop-ups"
- Okay, kind of.I have an Excel file that, when I click on particular cells - and I'm beginning to think that's defined as "any cell" - Excel "generates" a FileOpen for the spreadsheet that's open, in an endless loop.Excel 2002. Windows XP.Has there been a serPoint value changed by question...
- Tags: brifd@..., Excel File, Microsoft Excel, software
- Q&A 2005-02-23
- excel question
- I'm trying to make my work schedule on Excel and I want to add in a line such as:9:00a-2:00p. Can excel add something in the same line? Can you put =SUM(A1+A1) or something like that?If not, and i'm sure you can't, is there any suggestions for me?
- Tags: Microsoft Excel, andy7580@...
- Discussion threads 2007-05-24
- How to paste without link in Excel
- Software: Excel 2003Problem: Excel automatically adds a link to formulas during a copy/paste operation between workbooks.Goal: I want to copy formulas from Workbook 1 to Workbook 2 without links to Workbook 1. In other words, I want to duplicate the formulas in a range of cells that I wrote in...
- Tags: Microsoft Office, Microsoft Excel
- Q&A 2006-08-09
- Excel Problem
- I have a user that is constantly haveing problems with Office 2000 excel locking up. When closeing excel it locks up. It only happens with Excel. The weird thing is that the changes made to the spread sheed are saved. Another odd thing is this...
- Tags: Microsoft Excel, Microsoft Office, Desktops, PC
- Q&A 2004-11-08
- << Previous
- page 1 of 1
- Next >>
