A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
Pivot range update on mulitple tables by aablank
I am using the same range for a number of pivot tables. If I add to the data, is there a way to update all of the tables at once? Right now I need to update...
September 15th, 2003 04:12 PM
by aablank Go to last post
0 1,110
Worksheets by Walter Payne
My worksheet is long. How do I divide it and still have the information linked to the first page.
September 17th, 2003 10:06 PM
by Walter Payne Go to last post
0 236
How can I sort a Table in excel which refence other cells with values by Dave Allen
I am trying to sort a section of a worksheet which contains the values of other cells. i.e Cell C3 contains the value of Cell A1 (=A1) Cell C4 contains the...
September 18th, 2003 09:58 AM
by Dave Allen Go to last post
0 405
unexpected result on average of 2 vlookup by Anon
"daredelsol" wrote in message ... Hello. I have two VLOOKUP formulas that give the...
September 18th, 2003 10:26 AM
by Anon Go to last post
0 198
No More Custom Number Format ERROR by James
I am working with a model in which I am converting to a current scenerio. When I go into a specific cell to change the link it gives me a error that reads "No...
September 18th, 2003 03:13 PM
by James Go to last post
0 850
Autocorrection List Function???? by Miguel Cazares
Hi!! I just had been installed MS Excel 2000 and when i begin to add information, each character i type, appear an Error Message saying something like...
September 19th, 2003 12:16 AM
by Miguel Cazares Go to last post
0 192
Filter drop down menu font size by Jim Sullivan
When I filter my spread sheets and then try to access the alternatives in the drop down menu the font size takes the text outside of the field of view. How can...
September 19th, 2003 02:36 PM
by Jim Sullivan Go to last post
0 692
Draw text Boxes and Control Box Text Boxes ???? Confused by steve
In Excel 97 there are two types of Text Boxes those that are created by the Draw toolbar and those that are created by the Control Box toolbar. One seems to...
September 19th, 2003 03:07 PM
by steve Go to last post
0 885
Invoice Template; date problems by Annalee
I want to stop the invoice template from prefilling today's date everytime it opens an invoice. Does anyone know how to do this?
September 20th, 2003 12:40 AM
by Annalee Go to last post
0 385
Linking by Dawn
When doing a link to another program, borders are missing. Any way to fix this.
September 17th, 2003 09:33 PM
by Dawn Go to last post
0 263
Turn off From: Cc: options under Office by Carl
A user using excel and work encountered a spreadsheet that was sent to them added the ability to send from these platforms. How does one remove these options...
September 17th, 2003 06:29 PM
by Carl Go to last post
0 352
#N/A by Bob Phillips
thanks bob..that did it..thanks for taking time to help -----Original Message----- Steve, =IF(ISNA(vlookup_formula),0,vlookup_formula) -- HTH
September 15th, 2003 05:27 PM
by Bob Phillips Go to last post
0 443
Countif using Criteria "<>""" ? by RagDyer
Thanks Tom, Never heard of "UsedRange" concept before. (Lots'a things I've never heard of !) But are there any other functions with similar...
September 15th, 2003 07:11 PM
by RagDyer Go to last post
0 528
How to pass array variables in sub procedure by Ying
Suppose I have a sub procedure with array variables: Build_Matrix(Matrix_Dim as interger, MatDate() as Date, TimeInterval() as double) I want to call...
September 15th, 2003 07:35 PM
by Ying Go to last post
0 407
his own PR thrust by Hamza Jadallah El Hassan
Rethink the Cool + the Shoe phil knight had a dream. he'd sell shoes. he'd sell dreams. he'd get rich. he'd use sweatshops if he had to. then along came a...
September 16th, 2003 01:30 AM
by Hamza Jadallah El Hassan Go to last post
0 358
Pivot table - formatting by akk
Hi Anon, That option was ticked. Despite that, the formatting changes. -----Original Message----- "akk" wrote in...
September 16th, 2003 03:35 PM
by akk Go to last post
0 459
Dates parameters/logic by BILL
Not sure how to ask this and I am very much a beginner in EXCEL. I am trying to find a way to track periodic reviews that are required every time an individual...
September 17th, 2003 02:13 AM
by BILL Go to last post
0 308
Opening Excel sheet with macro's on XP machines gives error by Dhanashree Bhat
Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...
September 17th, 2003 07:02 AM
by Dhanashree Bhat Go to last post
0 985
using spell check on a protected sheet by Scott
Lauren, Same problem; I've tried every variant of sheet and workbook protection. My searches at microsoft.com KB/sppt yield no solution (nor does this...
September 17th, 2003 06:19 PM
by Scott Go to last post
0 771
If then formula by photohoward1
I am writing a spread sheet to keep track of a racing club. I would like to be able to enter the place of finish in one cell and have the points automatic in...
September 17th, 2003 05:47 PM
by photohoward1 Go to last post
0 246
Post New Thread


Display Options
Showing threads 1 to 20 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.