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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
"Automation error Catastrofic failure" by Francois Benadie
I got this message as soon as I open an excel file that has some macro's to do calculations and change some of the user interface. I think it is connected to...
October 20th, 2004 11:15 AM
by Francois Go to last post
2 135
"AutoPrint" type macro requires tweaking by 1drunkbrit
Hi everyone For quite some time now, I've been using 5 near identical macros to help me print off some bi-monthly reports that use an "overview" sheet that...
August 24th, 2005 08:04 PM
by 1drunkbrit Go to last post
0 192
"Avanced?" Filter by comotoman
Is there a macro or a way to base auto filter on a cell number. a6:a100 is the filter area. (numbers 1-12) d4 could be a number from 1-12 i would like...
October 4th, 2005 05:04 PM
by Debra Dalgleish Go to last post
2 152
"average" IF by mpanty
Hi. I have a table with rating values for each game my team plays, and the games played belong to different categories (league, friendly, cup etc.). My...
August 26th, 2005 07:20 PM
by mpanty Go to last post
5 164
"Average" with error DIV/0 by agenda9533
Taking average from data below I get DIV/0 Error J42=AVERAGE(J40:J41) J40 00:16:40 J41 00:09:53 J42 #DIV/0! Thank you
March 2nd, 2005 06:47 PM
by Dave O Go to last post
1 134
"AverageIF" alternative by Flutie99
Since there isn't an averageif, what is the best way to average a particular set of numbers? Thanks.
May 27th, 2005 11:03 PM
by JE McGimpsey Go to last post
2 284
"Between" in an IF clause by gavin
I have the following formula which works OK: =IF(ISBLANK(AJ2),"",IF(H240,'Jobs (2)'!F2*0.682,IF(H2130,'Jobs (2)'!F2*0.781,"0"))) But I need to add another...
May 2nd, 2005 09:27 PM
by Bill Kuunders Go to last post
5 134
"Bloated" Excel workbook by Shirley
We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder. paste to the desktop, fill it in with the day's accounting figures and then email...
February 24th, 2005 11:21 AM
by Shirley Go to last post
5 156
"calculate" at bottom of worksheet by bruno
"calculate" appears at the bottom of my worksheet. It seems to be some type of circular reference and some of my formulas are not being calculated, even when...
(Multi-page thread 1 2)
June 14th, 2004 06:07 AM
by JE McGimpsey Go to last post
11 705
"Calculation" in status bar by rich
I have one woorkbook that the "Calculation" lite in the status bar stays on. I do not have "manual calculation" turned on. How can I fix?
October 8th, 2004 08:20 PM
by Dana DeLouis Go to last post
1 130
"Can't Create Backup FIle. Save [filename] Without Backp? by SidBord
I get the following message every so often when running Excel 2003 under Win XP: "Can't create backup file. Save without backup?" I respond: "OK" "Your...
September 10th, 2004 07:33 PM
by Dave Peterson Go to last post
1 394
"cannot be accessed" error opening file on network by Steve M.
Using Office Excel 2003, I get the error message "filename.xls cannot be accessed. The file may be read-only..." that is in the article 835234, but I get it...
October 25th, 2004 05:08 PM
by Lady Layla Go to last post
3 119
"cannot empyt clipboard" error by AP
I am getting the cannot empty clipboard error after every cut/paste or drag/ drop. I'm running Windows XP & Excel 2003. Is there anything to fix this?
February 9th, 2005 06:37 PM
by AP Go to last post
0 121
"change order form" by Dee
Does anyone have a change order template that I can review?
February 3rd, 2005 12:05 AM
by Dee Go to last post
0 130
"Check Marking" a cell by FVC
Can I format (via Macro???) a cell so that if the user left clicks on the cell a check mark appears without using the Control Toolbox. The cells with such...
April 8th, 2005 09:21 PM
by David Go to last post
2 69
"Client Safety Options do not allow pass through statements to th. by hating2003
Whenever I try to update a report linked to an OLAP cube in Excel I get the following error: "Client Safety Options do not allow pass through statements to the...
September 29th, 2004 10:53 PM
by Gord Dibben Go to last post
1 129
"Clocking" events in Excel by Pete
I’m writing a psychological test which will flash simple 4-choice multiple choice questions and score how quickly you hit the 1, 2, 3 or 4 key. I need to...
October 22nd, 2004 03:43 AM
by Pete Go to last post
4 138
"Combo Box - getting control combo box to stick in place in worksh by ajr
Greetings, I am using a combo box from the control toolbar and every time I print or print preview, it moves the combo box placement on the worksheet. How...
February 15th, 2005 08:45 PM
by ajr Go to last post
0 68
"Combo Box - getting control combo box to stick in place in worksh by ajr
Greetings, I am using a combo box from the control toolbar and every time I print or print preview, it moves the combo box placement on the worksheet. How...
February 16th, 2005 03:05 AM
by Dave Peterson Go to last post
1 89
"combo box" by adam.ronalds
how do i get the control combo box to stay in place on the worksheet? I print or print preview and it resets the placement of all my control combo boxes.
February 15th, 2005 09:47 PM
by adam.ronalds Go to last post
2 127
Post New Thread


Display Options
Showing threads 21 to 40 of 139764
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 06:39 AM.


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