View Full Version : Microsoft Excel Misc
- error opening files
- pivot table vs. spreadsheet
- leading zeros
- Excel 2003 and backwards compatability
- Sum formula that stays constant
- save only filtered results to csv/txt file
- Portrait and landscape views look same
- Loseing Formatting in Workspace
- how many items for a catagory have been sold
- comparing values from cell to cell
- Landscape View
- How do I get rid of #N/A
- How do set different widths for the same column?
- Weekday formula
- Excel
- Workspace link corruption
- How to open workbook from workbook template without hardcoding
- 'Replace' Query
- Error Opening Excel from Windows Explorer
- Microsoft Hot Fix 821136
- Email & Excel
- Using selection to add cells to formulas - want absolute reference.
- Timing calculations
- Counting Text in cells
- Is it possible to print the contents of the Object Browser?
- Deleting rows in Excel based on criteria
- Printing the file path name is Excel 2000
- Macro pause for input
- Format Text Data Type
- Need help changing cell labels
- Conditional Sum Wizard?
- personal.xls locked
- rounding time to 15 minute interval
- dynamic range
- Data validation and Named Range
- REFERRING TO DATA IN A DIFFERENT WORKSHEET
- excel macros
- workbook extension
- Unwanted quotes in Unicode.txt saves
- thanks
- need sum from another workbook
- open older version of excel in excel 2002
- Restoring older version of spreadsheet
- Vertical Text
- Pivot Tables
- Protecting and Unprotecting Multiple Worksheets
- AutoFilter
- Saving backup workbooks Excel 2002 SP2
- "Save" and "Save As" dialog box does not appear.
- Converting Quatro Pro spreadsheets
- Document Properties - printing
- Copying/ moving formula between workbooks.
- smooth scrolling
- COUNTIF Function
- Office XP installation trouble
- Lookup a row meeting several criterias
- Pivot table - data errors
- Excel Sorting
- Default Negative Number format across versions
- data validation - banning blank entries
- Size of excel components
- Formula needed please
- Send To from Excel
- 2nd cry for help-3 variable length lists of data that need to be concatenated in to one column
- xyz to ascii
- Toolbar and view
- 1st row not always recognized as header row when sorting
- Find and Replace through functions?
- Cell contents displayed on toolbar
- XP Pivottable referances
- Quarter format date
- excel shared file
- Sumif function
- Moving Rows to Columns
- Text size in a drop-down list
- double opening files
- Formatting the Date in Header/Footer
- Help with a Copy and Paste Macro
- Customer response time
- Sumif?
- Macros
- change field number automatically when printing
- Delete Blank Rows
- Re: Unhiding Personal.xls
- Using dates in formulas
- formating multiple worksheet via print preview
- Control Tab for Combo box
- YTD calculation
- can someone please help me with this
- importing from outlook
- Worked like a charm - thanks!
- Save Data By Date
- remove word from Excel's custom dictionary
- formula bar formatting
- No new fonts allowed
- How to Foolproof data entry? DataForm
- Retrieving Text from Cell Comments
- stop excel 2002 from opening a new workbook each time a new spreadsheet is opened
- HELP!! Excel 2002 taking up my whole taskbar/ start bar
- counting number first entry on line
- Tab Key
- setting up "find and delete row" macro?
- counting first entry on a line
- How to Add a Tab to an excel formula
- a
- Saveas CSV with data in "quotes"
- How to change cell colors based on an IF statement formula?
- Auto Number for Invoice
- Converting numbers into text
- Splitting formulas in cell
- Excel Lables
- Copying data without blank cells, and only certain cells
- Excel: Name Range Values Reset After Refresh Data + ReCalc
- No "Assign Macro"
- file comparison
- Email attachments Books vs Sheets
- Hiding empty rows in a Pivot Table
- Mysteriously large worksheets
- If a number is greater then zero then unhide the line
- Sorting
- Excel Spreadsheet
- automatic Macro at start
- Pivot table formats
- Can you sort by format or color?
- Highlighting Rows
- Excel 2002 keeps freezing
- Excel
- Is there a way to elliminate the "Save Before Quitting" Message?
- Excel 2002 can not open earlier verion of excel?
- Disabled "Save" and "SaveAs"
- Excell 2003 XML?
- Help with an If statement
- office xp
- Automation and memory corruption - long
- WinMe Excel 97 Not Enough Memory to Run Microsoft Excel
- Drag and Fill Increment???
- More than 9 recent files used
- Small problem or big problem? No workbook at startup
- Display Tab name in Cell
- incorrect Trim-result
- Excel in cell editing
- I want a special protection
- Error while saving file in arabic folder
- microsoft word
- Password related issue
- Autocorrection
- drop down boxes
- digital certificates
- How to open excel with in IE
- Sheet References in Cell
- Auto fill
- Convert mm/dd/yyyy to yyyymmdd Date format in Excel
- Link To A Cell From Chart
- worksheet to macmail address book
- Sorting Text Column by Most Frequent item
- question about zeros
- Tools-Options Error message
- Listbox not allowing access when sheet is first opened
- COUNTA in Array Formula
- Hiding & Unhiding Columns & Rows
- Can it be done?
- Formula for 1st of month following 30 days
- spams
- Exporting MSWorks files
- pass comboboxvalue to another userform
- .xls files Win 98 to Win XP home
- Rotation doesn't maintain aspect ratios on wordart objects
- Excel counter
- Filter & Sheet Protection
- sort order
- Calculating with Textboxes ...
- Sorting data problem
- hyperlink e-mail
- purchase order template
- adding in a row
- Can I sort by the strike-through characters ?
- Formula Needed!!!
- How do you include a value from a cell in a chart?
- Countblank
- Row hight in millimetres
- Microsoft Excel
- auto filter macro
- auto filter macro
- auto filter macro
- File format not valid message
- Formula needed if it is even possible
- Formula to determine range
- Check out important pack
- Auto change Caption on Command Bar via formula
- Code reference changes
- How to have auto dialog box showing when selecting cell
- Copying cell formatting and data validation in protected worksheet
- PDF 4 Toolbar will not go away
- Help Required with strange error message?
- No Workbook on open
- Over functions don't work now. Help
- address list in excel need to get into outlook contacts
- Mileage report
- Explanation of VBA procedure
- Can not Transpose with out destroying my formulas
- Re: Excel Status Bar
- help in excel functions
- sort and special chars
- How do I convert formulas to values? Help appreciated!
- Formatting Issues
- more about Excel
- excel add-ins
- scroll bar
- Trim blank space within text
- how do i restore file deleted drom recycle bin
- Cell to "blink"
- Page breaks
- display problem
- Update a text box on a userform
- Applying formulae to new rows
- Not printing in Excel
- Copying rows from Subsidiary Files to a Master File
- Excel2000: Dynamic named range from area with formulas
- Quick way for removing manual pagebreaks
- Sort not working while sheet is protected!?!
- Re: Pivot Table - Named Range
- multipy 2 collumns
- Re: multipy 2 collumns
- Re: Why do numbers not display right?
- Re: multipy 2 collumns
- Re: multipy 2 collumns
- No control buttons on title bar (no minimize, restore or close)
- Lock a worksheet
- Formatting numbers as text
- Printing dotted circles
- Re: Why do numbers not display right?
- lock a worksheet
- save first sheet in new workbook
- Currency in text box
- freezing row and column headings
- Warning Symbol
- Document Properties and Custom Fields
- Supress col/row increment with copy
- Excel stuck in a weird mode
- how to increase the columns in a spreadsheeet ?
- Nested If Statement
- Gradients of curves at a tangent
- VLookup Problem (Bug?)
- HTML & Excel
- Import External Data
- Turn off all Hyperlinks
- File SAVE AS ... use cell value as pasrt of name
- copying macros
- excel download
- ALT + ENTER
- Getting values from a graph
- excel 2002
- Graph Source Data
- When opening Excel get File Not Found error
- look up problem
- Re: Excel 2000
- Lookup question...
- Excel frustrates me
- Converting data to Access database
- Determining if user has "write/save" permissions
- formulas show up instead of values
- Row headings on BOTH sides of spreadsheet
- excel printing
- Making a spreadsheet fit the page
- Macro "Ghosts"
- Printing Worksheet Name
- Cell shading not working in Excel 2003
- Replacing cell with text
- Combo Box
- #Value
- Error messqage on opening Excel docs
- Circle value in cell
- Protecting HYPERLINK cell disables the link
- Auto Launching Template
- tabulating a survey..
- Looking up data from another sheet
- Month formula always returns Jan
- templates
- Summing within an array
- Re: Month formula always returns Jan
- Formula
- drop down lists
- Increment Question
- minimize, restore/maximize buttons are missing from worksheet
- Worksheet name in copied formulas
- 550 Sender verify failed
- Sorting
- How to change the Month and Data to be calculated?
- regression
- Report manager & creating PDF files
- Add two expressions ?
- removing auto-format /smart quote characters from excel and access data
- Date to text
- Ho to create an Image Control?
- XLS to MHT bloat
- Calculated field in a pivot table
- excel 2002 - file growth out of control.
- Combo box using outside data
- Budget tracking tool
- Excel/Access
- create wmf in excel
- Re: colm.obrien@digneygrant.co.uk
- Spinner
- Autosave? Where is it stored?
- Auto Increment Office XP Excel Spreadsheet ?
- Lost Formula Bar
- getiing a certain value
- mail merge
- Extracting the year from a date
- How to shift address listings from row list to columns?
- Preserving Cell Formats in Excel Query
- Multiple sheet .xls file to .mdb file
- Printing Ranges
- 18 digits
- Pivot: where does Excel store the data?
- Delete a line that matches certain criteria!
- Re: colm.obrien etc
- ! Message: No more new fonts
- Pivot tabels - auto foramtting when doubleclicking
- Pivot Table Query
- Populate form txtBox with current User & Date
- Formula help
- "merge and center" grayed out
- External Data Retrieval trouble
- Workbook.htm - Freeze Panes
- Runtime Error '1004'
- Excel 97 to Excel XP (default margins)
- Default values?
- Oval fill and color
- Look at these correction patch for Windows
- Drop down boxes
- array function!
- Large Excel Spreadsheet Pasting
- Split screen
- Counting BOLD text
- hyperlink
- VBA Toggle
- Excel 2003
- unwanted characters inserted
- ###### in Excel Column
- Tab Formatting - conditional
- auto save
- no new fonts may be applied...
- unwanted spaces in mail merge docs
- Authoring Excel Macros
- if SUM = zero, then display nothing... how?
- excel 2000 doc looks for pages in the local drive b4 opening
- Change date formatting
- Excel 2002(XP) Startup
- Looking up a date and also a word for a sum function
- code to close
- Global Styles
- Macros
- Correlation Slope
- Questions on VB and VBA
- Re: Sperm cell counter using Excel
- Excel Text Function
- Excel macros
- toolbar hyperlinks
- Cell Validation using List and Variable
- Combinations
- Fix Value Statement
- Control C to Copy
- Restrict Print Function
- Ordered categories in Pivot tables
- open excel file in word
- Sum function
- Help on templates
- shared spreadsheets
- "Save As" Missing in File Menu
- Julian Date
- Excel VBA: How to select only rows containing data?
- 2 sumif functions in one formula
- MAC Excel flipping im ages
- How can I determine minute serial number values?
- Using the combo box from the forms toobar
- Custom addition formula
- Print format changes when emailed to others
- Excel and MSworks. Compatible?
- Lost password
- Rename sheet tab based on value in a cell
- Pivot Table Logic
- Excel 2003 Reference books
- Send This Sheet feature
- Formula To Sum Four Highest Numbers In A Range
- Help with a template
- Anniversaries in an excel generated Calendar
- Dialog box after display DPI setting change
- What problems can I expect with 1000 hyperlinks?
- Excel spreadsheets and templates
- Excel 2003 Split cells
- Sumif
- Need formula
- Emergency Operation on .xls file
- getting data across spreadsheets
- Column headings switched to numbers
- Import text from Access results in squares at end of para
- (repost) Data Validation and Named range.
- Shortcut key for copy not working
- Re: Other functions don't work now. Help
- Excel screen views
- how do you calculate a test statistic from excel??
- Shortcut key
- Other functions don't work now. Help
- Forms
- help with lookup
- Saving
- Average of Generated Data Results
- Interest Rate Calculation
- Formula gets rejected
- What is wrong in this formula?
- I need help affecting the Values of one cell by entering data into another...
- Deleting zeros when mail merge
- Use code to stop "...contains one or more links that cannot be updated"
- Excel file size
- Payroll calculation problem
- How to show the next number depending on other data
- Large file size in Excel
- Auto filter reset
- Select next blank cell
- sorting and cell reference
- Renaming columns and rows in Excel
- Varying data ranges
- Autofill Cells in Excel XP
- Cell referencing in VB Editor
- Autofill Cells in Excel XP
- Formula to find the first/third monday of each month.
- More problems using an IF statement.
- excel 2000 message - 'cannot use object linking and embedding'
- excel.exe has generated errors and will be closed by windows.
- mail workbook
- Excel will not open associated file when double-clicked
- disabling data updates within excel pivot table
- Drop downs list on every line for a specific column?
- saving .xls to .csv
- Format Cells Does Nothing
- Drop down on every Line for a specific column?
- dynamic dependent list
- Startup error
- Error in Excel
- Drop Down Lists won't work
- Unable to Read File
- Custom validation with formula
- Drop decimal and don't round
- Circular reference email
- Tab Names
- quick call on excel
- Data in cells is actually labels not values
- sort whole sheet by one column?
- Excel
- Conditional formatting - line width
- Eliminating Blanks
- How can I delete rows that are hidden.
- Force CSV page Break
- Negative Time
- Re: Pivot Table
- Deleting Hidden Rows
- Re: Circular Reference in Excel
- Column widths and linking worksheets
- Loading CSV and Special character
- A program is trying to send mail using Item.Send
- Function to Copy all sheets into one sheet
- Dragging in Excel
- Excel - Outlook link
- Import data from Parameter Query
- Cannot assign to range object
- Calculated Item overrides "Show Items with no data" checkbox
- Locked Row After Import of External Data
- Pictures n' music
- Autofit/Text Wrap
- creating special list boxs
- Eliminating a split
- Excel 2002 Task Pane
- change column widths w/o affecting rows above
- Can user enable macros after accidently chosing "open disabled"?
- Histogram R1C1 problem
- Custom Format
- Fill Down based on variable, offset?
- Pasting in merged cells
- Currency symbol
- Row height
- looking for the one button take me from Sheet1!C4 to Sheet2!C4
- cant open Excel 2000 workbook with macros in XP
- counting data in two columns on worksheet that meet certain criteria:
- page numbering
- pivot table changes when data is refreshed.
- Thank You!
- Using Excel Macros with Sharepoint Team Services
- BVE??
- Data Form and Time Format
- Nested If Function...Please Help
- Generating Invoices from an Order Sheet
- Export Macro
- RE: Linked Workbooks Not Updating
- Export Macro
- Excel grid lines printing problem
- Wrap text, or sort cells.
- Can Adobe Acrobat print all worksheets in a workbook?
- Pricing lookup
- Style available all sheets new or old
- SUMIF and a criteria range
- Graphs in Excel
- Auto Unwanted entry in cell
- Cells highlighting on their own (Excel 2002 -- SP2)
- Ignore Blank/Data Validation
- using common data in multiple sapreadsheets
- Check this important pack for Microsoft Internet Explorer
- Excel macro
- getting cell values from multible sheets
- Slow printing with a receipt printer
- Ending Excel
- search feature in Excel
- Error Message
- IF function
- Spreadsheet Options
- Changing font for check box
- Auto shapes in excel 2002, SP-2
- out of date file
- Excel spreadsheet Date formatting
- trendline: how to set custom formula/function if have both Log and Polynomial
- Enabling .Count method
- To convert minute into hour and minute
- [OT] Math quiz
- Data Validation - List
- Hide path in macro warning box
- Re: Formula needs tweaking - HELP!!
- Calculating date difference
- How many cells match a text string?
- Protect sheet
- Select ALL + Paste function in EXCEL XP
- Find and replace with formatting
- Data Validation
- Shortcomings in "Rank" Command?
- How to change a chart in a shared workbook?
- Removing Menu Option in VBA ( grey one out ) ?
- Auto save overwriting original copy
- changing settings: comma into point
- Using a txt string in formulae
- Extracting days from a date
- Sorting
- cell count of 'grouped' cells
- Modify existing custom cell format (Excel 2000)
- Row/column grid lines
- Padding cell length with leading zeros
- Checking if files open prior to running macro
- Using a result as a cell reference
- Pivot table to sort by 2nd Row data field
- Formula Help
- Object linking and embedding error
- Flipping data around
- Cube root
- Possible to run a small macro every time I change a value in a cell?
- view comments in cell
- Re: Excel Solver Function
- Have data circulating between sheets
- Landscape prints/previews in portrait
- Find the age from date of birth
- Drop Down Calendar
- Smart hyperlinks
- Excel missing file
- color tab on spreadsheet
- IF-function
- Copy entire work book
- Pivot table of multiple histogram
- See critical pack from the M$ Corp.
- Date changes when copied
- Non-VBA formula to find 2nd Sunday of a given month
- Re: Show or hide outlined data
- Setting length of all cells in a column
- EXCEL and Query
- Dynamic Dropdown on every line for a specific column
- XLS File
- excel file question
- automate solver
- Keystroke shortcuts for Mac
- Data Validation - List from another worksheet
- Excel 97 Formatting error
- excel spreadsheet in word
- Exel 2000 - Budget Spreadsheet using FUNCTIONS?
- Slow opening of workbook
- Pivot table problem
- Excel Budget
- Excell problem
- Looking for an optimization algorithm
- drop down box behaviour
- Replace cell of column with cells of other worksheet
- Counting problem
- New Toolbars disappear
- deleting checkboxes
- Have a formula print to different worksheet
- A quick question
- Summing two columns
- Scroll Bars - Form Tools On Worksheet For A Table And Chart
- A Problem in CSV file
- Date Conversion
- Can vlookup handle more than one match, if so how?
- Nesting Sheets
- Cell content as a filename in a link ?
- Control Objects
- no formula calculation
- Excel switches back to fisrt sheet in a file
- Document Not Saving
- long formulas are truncated in Resolve Conflicts dialog box
- Colour in Cells containing dates
- Printing from Excel
- Matching Issue
- Excell 2000 - Cannot open Invoice spreadsheet
- comparing two spreadsheets?
- Auto formula when putting in date
- Multiple Excel spreadsheets will not respond when opened from server
- "1" + "2" = 0 (?)not what Help says
- last entry formula
- Print result is different than preview
- Web Query and Line Break <BR> tags
- To Define Name Instead of Range
- Password error
- Function/Formatting
- Best book to learn excel?
- Copying multiple cells formula and paste as Values in same locations
- Excel calendar templates
- 2nd line of wrapped text
- new to excel
- Copy & Paste from internet???
- Copy & Paste Problem
- Roundings
- Roundings
- Prove this important package that came from the MS
- Roundings
- Roundings
- Complex formula
- Conditonal format based on another cell value
- Control Object
- question for Excel file
- Print showing formulas
- SORTING BY "text"
- export from outlook to excell
- BLANKS AND SPACES
- How to get different windows for Excel spreadsheets
- Lock format changes
- Converting my hours into dollars I'm a total novice!!!
- Reformat data from 3 columns to 9 columns worksheet
- Data Command Disappeared
- race odds
- macro - tracking cursor position in macro
- XL and the Web
- How do I display all formulas?
- outlook express password
- time in the Y-axel...
- Column formatting not accepted
- Auto change of Row number within Formulas
- Numbers appearing in decimal form
- Problems With Data between datasheets/workbooks
- Next Referenced Cell
- Autofilter and protected sheets
- Program excel function
- Merging Excel Files into one.
- extracting data
- Excel crashes when columns are deleted or added to workbook
- Calling a subroutine from a module
- Restore button does not work
- Drop down menus problem Win95
- Time Calculation
- microsoft XL
- when opening Excel Files
- countIF?
- Lotus to Excel Problem
- Decision Trees in excel
- running total of the difference of 2 columns?
- learning excel
- Complex Lookup in Excel for values not in same row/column
- merged cells data
- question on pivot table
- Lookup with multiple criteria on diff worksheets
- Copying rows from Subsidary Files To Mastersheet with Formulas
- Extracting football league position to another work sheet
- Copying cell formulas to another workbook?
- Blank excel spreadsheet
- Array Function LINEST
- Start a macro inside an IF-function
- Re: Start a macro inside an IF-function
- Simple percentage formulas
- Array formulas
- I'm stuck...
- Filename -> Image
- random names generator
- Limits on number of columns
- Office 2003 Beta version
- Help please - Character display
- Column limitation - why?
- open and save as... buttons
- Databases
- Looking up the rounded value in a cell, not linking to the value.
- Generating continuous lists using lookups
- Microsoft's square root table macro
- converting from 2002 to 2000
- Help!!!!
- Help I'm Stuck...Delete cells that don't meet ascending value criteria?
- Auto insert time in pocket MS Excel
- Multiple comparison of list items.
- Function Help
- XP Problem - toolbar changing path of assigned macros
- counting months
- store data
- Upload Pictures in Excel to a database
- Taste this correction pack for MS Windows
- Copying Conditional Formatting ONLY
- Charting dates
- File Origin 932:Japanese
- Can't get Excel from Office '97 to work in Winows ME
- importr csv into excel template
- Coloring Sheet tabs
- Lookup based on currently selected cell
- Named range lookup
- round
- Excel
- Countdown Clock
- Convert Date in month?
- Saving Excel file in arabic language
- Use same format as another cell
- EXCEL HEADINGS
- custom built Excel macros
- Date format
- column heading
- Help with drop down boxes/menus
- Changing Short Menus (Right-Clicking)
- this
- Formula
- Using Current Time
- removing empty rows
- New time system in decimal format
- Hourly time calculation
- Excel displays formulae, not results
- Cell Character Limitation???
- Vlookup Macro
- How did I break the cell display limit?
- How did I break the cell display limit?
- histogram R1C1 error
- Excel files won;t open
- Auto refresh on opening
- printing multi-worksheet workbooks
- iterative caluclation
- Data Import/Export
- Unwanted excel conversion text to dates
- A3 / Custom paper size
- Saving to Network Share
- Displaying Date in Textbox?
- Conditional Formatting question.
- Insert Picture IF criterea is correct???
- Lookup
- Cell Reference in text
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.