Pages

Search

How to turn off check for Updates - Microsoft Office forums

How to turn off check for Updates - Microsoft Office forums


How to turn off check for Updates

Posted: 10 Feb 2005 07:31 AM PST

Within say word under help. check for updates. This takes a user to the
internet. We do not want our students to go to the internet. WE have
restricted them everywhere but here

"Jim Hall" wrote:
 

Problem with the CIW (Custom Installation Wizard).

Posted: 10 Feb 2005 06:03 AM PST

Hi, Kor,

I would suggest this:

Run setup /a to create the administrative installation point
Patch the AIP with SP3
Create your transform to install Office (already patched)

See "Applying Office 2000 SP3 to an administrative installation point" in
the article:

Microsoft Office Assistance: Office 2000 Service Pack 3 (SP3):
http://office.microsoft.com/en-us/assistance/HA011524761033.aspx


--
Susan Ramlet
MVP - Office

Please reply to the newsgroups where others may benefit.


"Kor" <microsoft.com> wrote in message
news:com... 
fine 
FYI I 


outlook standalone

Posted: 09 Feb 2005 07:45 PM PST

MSDN subscriptions can be had for as little as $1500 US. Don't know the
conversion rate but the rate you cite is much higher than even the most
expensive MSDN subscription.

Also, to the OP, I should have said "Outlook" is available as a standalone
application, not "Office."

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to the
(insert latest virus name here) virus, all mail sent to my personal account
will be deleted without reading.
"Miss Perspicacia Tick" <com> wrote in message
news:MESOd.3430$buzzardnews.com...
| M130 wrote:
| > Does anyone know if Outlook comes in a Standalone client without
| > having to purchase the entire suite?
|
| You know Google exists for a reason. Here's a clue - use it!
|
|
| If so, is MSDN the best way to
| > download?
| > M
|
| Sure, if you want to pay £5,000+ for a £100 application.
|
| --
| Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
| on salads.
|
|


OS not configured to run Application

Posted: 09 Feb 2005 12:27 PM PST

Problem solved.
Something messed up the MS Word/Excel shortcuts on my desktop. During the
repair install, I checked the restore start menu also.

Now they work when I use the start menu, but they don't work when I use the
icons. Guess I'll replace the icons...

Put this in your bag of tricks folks!
Thanks for your help
Jim

"Lanwench [MVP - Exchange]"
<donotsendme.unsolicitedmail.atyahoo.com> wrote in message
news:e#phx.gbl... 


Where can I get Frontpage2003 from? I have Office 2003 Pro

Posted: 09 Feb 2005 11:17 AM PST

Hi Simon,

MS chose not to include MS Office Frontpage 2003
in any of the MS Office 2003 Editions. It's a
standalone app.
http://microsoft.com/office/frontpage/howtobuy

========= 
news:com...
I have Office 2003 Pro bought from PC World, yet Frontpage is not on it. On
the Microsoft site though, when you order a Frontpage demo, it comes to the
same 30 2003 trial. Where can I get it from? >>
--
Let us know if this helped you,

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 Editions explained
http://www.microsoft.com/uk/office/editions.mspx


Can I uninstall Office XP if I've installed Office 2003-pro?

Posted: 09 Feb 2005 09:21 AM PST

If your copy of Office 2003 Professional is not an upgrade, then you can
uninstall Office XP and not lose anything except the Office Shortcut
Bar, which is not included in Office 2003. If any problems arise, you
can fix them by running "Detect and Repair" from Start | Control Panel |
Add/Remove Programs | Microsoft Office 2003.

Jolson46 wrote:
 

disabled but still installed???

Posted: 09 Feb 2005 07:55 AM PST

Hello Bob,
I get only outlook if I use the custom install and go the long way. I
did however find the outlk11.msi file in the office 2003 pro that we had.
The MST ran great.
Thanks,
M130

"Bob Buckland ?:-)" wrote:
 

what does my trial cd look like?

Posted: 08 Feb 2005 05:25 PM PST

sarap37 wrote: 


HTF should we know?! Here's a clue - it came with your new computer, how
about contacting the manufacturer? MS does not will not and, indeed, cannot
support OEM-supplied software and/or hardware. All support - including
replacement keys and media - is the sole responsibility of the OEM.
--
Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
on salads.


Free Trial for Office 2003

Posted: 08 Feb 2005 05:19 PM PST

Two more ideas: Do you have Windows 2000 with Service Pack 3 or higher,
or Windows XP? If you have set up multiple user accounts in Windows,
are you signed in as Administrator when you try to install?

Jim wrote:
 

.jpg .gif .bmp file associations gone, upgrade from Office XP to 2

Posted: 08 Feb 2005 01:47 PM PST

Hello,

Thank you for posting.

From your post, my understanding of this issue is: After upgrading Office
XP to Office 2003, image file associations are no longer configured as you
like. You would like image files other than .jpg to be associated with MS
Office Picture Manager, and to have .jpg files associated with Photoshop.
If this is not correct, please feel free to let me know.

In order to assiociate image files with MS Office Picture Manager, you can
change these settings in the Picture Manager (by default Start > Programs >
Microsoft Office > Microsoft Office Tools > Microsoft Office Picture
Manager). When the Picture Manager is opened for the first time, you
should be prompted with a file association dialog box where you can adjust
these settings. If you are not, you can open this dialog from the tools
menu (tools > File Types). In this dialog, you can associate image files
with the picture manager.

To ensure that .jpg files are opened with Adobe Photoshop, you can shift +
right click a file in Windows Explorer, select 'Open with' and 'Choose
Program'. In the Open With dialog box, select Photoshop and tick the
'Always use the selected program to open this kind of file' option.

Please let me know if you have any other concerns, or need anything else.

Hope this helps!

Sincerely,

Dana Brash
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.


-------------------- 
XP to 2 
users 
"Photo 
Manager". 
associations. 
the 
files 
not 

How do I Install Office XP to Run from CD?

Posted: 08 Feb 2005 06:27 AM PST

Office XP has the 'run from CD' option disabled.
The files needed are in compressed .cab files rather
than in files that can be used directly.
http://support.microsoft.com/default.aspx?scid=kb;en-us;284463&FR=1

The change was part of reducing the number of CDs from
what was used in prior Office editions.

======
<<"StudioSaluki" <microsoft.com> wrote in message
news:com...
I need to install Office XP so it will run from CD. I cannot install the
program first and then change the program's installaton type through the
Add/Remopve feature as was suggested in one article I read. Due to our
company's support policies, I want to install as few files as possible on the
hard drive. When I try to do a custom installation, the 'Run from CD' and
'Run All from CD' options are not available. Any help would be appreciated.
Thank you.>>
--
Let us know if this helped you,

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 Editions explained
http://www.microsoft.com/uk/office/editions.mspx


Office Service Options

Posted: 08 Feb 2005 05:19 AM PST

Yes Bob, sorry I should have stated that in the original question. This has
been disabled and it doesn't appear to effect the changes it looks like it
should.

"Bob Buckland ?:-)" wrote:
 

Upgrading from Student & Teacher 2003 to Pro

Posted: 08 Feb 2005 01:19 AM PST

Gyorgy Moldova [MCSE, MVP] wrote: 


To add to, and slightly correct, what Gyorgy has said (though he's basically
right - the STE does *NOT* qualify you for an upgrade to future versions)
you cannot upgrade between products of the same family - it's considered a
crossgrade and is not supported.
--
Facon - the artificial bacon bits you get in Pizza Hut for sprinkling
on salads.


Installing my own Office product over computer bundled trial versi

Posted: 07 Feb 2005 08:27 PM PST

I'd almost say that it was mandatory.... Our Dells came with MS Works
w/Office. The first time I tried to install over it and I ended up with
multiple Word installs. Interesting trying to upgrade from the Office Update
site... ;-(

Uninstall first.....

--
Regards,
Hank Arnold

"garfield-n-odie" <microsoft.com> wrote in message
news:phx.gbl... 


Can't Open Files or Load Access on New PC

Posted: 06 Feb 2005 09:29 AM PST

Search for the OFFICEAV.DLL file on your hard drive (include hidden and
system files/folders in the search options). If you find it, note the
directory path where it is located. Close all open applications. From
Windows, click on Start | Run. In the Open dialog box, type the command
(including quotes):

regsvr32 -U "C:\<path>\OFFICEAV.DLL"

but replace <path> with the directory path for your OfficeAV.dll file.
Click on OK. You only have to run this command once (not every time you
restart your computer). You should get the message:
"DllUnregisterServer in C:\<path>\OfficeAV.dll succeeded." Reboot the
computer. Does the problem persist?


barbaraeh wrote:
 

Why won't my computer let me download Office 2003

Posted: 06 Feb 2005 09:05 AM PST

Miss Perspicacia Tick wrote: 

Wow... meow!



Can't convert my 60 day trial

Posted: 06 Feb 2005 08:59 AM PST

You should click on Help | Activate Product. I think you clicked on
Help | Detect and Repair.

sj586 wrote:
 

how to remove Office icon in the taskbar notification area

Posted: 05 Feb 2005 03:42 PM PST

ay2001 <com> wrote:
 

Huh? They do allow you to keep it from appearing.
--
Brian Tillman

Office 2003 Re-Activation

Posted: 05 Feb 2005 05:33 AM PST

I, too, build OEM PCs and use OEM software. Sometimes, I'll load the said
software and will try to activate it when the wizard tells me that it can't
be activated -- a.k.a. already been activated. I know it's BS as i just
unwrapped the software & know it's never been installed prior to this point!
I just call MS (the activation phone #) and explain to them what happened.
They should be able to help you out too.

02-07-05
1506
Tome

"wincom" wrote:
 

outlook sux

Posted: 04 Feb 2005 08:37 AM PST

Or even READ the admonition that appears when you open Outlook for the first
time and it says it found an exisiting account, would you like to import it?

There are seldom vendor solutions for user ineptness.


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, RedCaliSS asked:

| it automatically imported all my data from outlook express without
| asking me.. I did NOt want that to happen.. I wanted to start fresh.
| now how the hell do I undo M$ screw up?


Want to uninstall office 2002 and install 2003 due to corruption..

Posted: 03 Feb 2005 08:19 PM PST


Thanks Sean, I'll check it out.
"Sean" wrote:
 

Office 2003 Pro Re-Install Problem

Posted: 03 Feb 2005 06:35 PM PST

If you're using Word as your email editor in Outlook, try turning that
option off and see if it helps. Other than that, I'm out of ideas too.

Scott wrote:
 

Office 2003 Transform over original install - failure???

Posted: 03 Feb 2005 11:26 AM PST

Bob, thanks, this is jts the confirmation I needed!

"Bob Buckland ?:-)" wrote:
 

Reading Word 2007 Windows files in WordX? Microsoft Office for Mac

Reading Word 2007 Windows files in WordX? Microsoft Office for Mac


Reading Word 2007 Windows files in WordX?

Posted: 24 Apr 2008 02:58 AM PDT

Very many thanks, CyberTaz, the job is now done and dusted!

A most helpful reply. I must confess that, alas, I've always found the MS websites more than a little user hostile and totally illogical so that's probably why I couldn't find what I wanted.

But I can rest easy now. Thanks again.
 

Help!!

Posted: 23 Apr 2008 10:57 PM PDT

On Apr 24, 11:12 pm, com wrote: 

Sorry, but why can't you get to Preferences? It's not in Word, it's a
directory on your computer. Search for each of the individual files I
listed using spotlight - you can find them that way if you prefer.

Setting .doc default to .doc, not .dox

Posted: 23 Apr 2008 04:50 PM PDT

Word> Preferences> Save, choose Word 97-2004 Document (.doc) from the Save
Word files as: list - just keep in mind that you'll be constantly working in
Compatibility Mode which will prevent the use of some of 2008's features.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 4/23/08 7:50 PM, in article caR9absDaxw,
"com" <com> wrote:
 

Punctuation marks " " and -

Posted: 23 Apr 2008 12:22 PM PDT

> On 4/23/08 3:22 PM, in article caR9absDaxw, 
Thank you!
Dan

unwanted automated inserts in Word document

Posted: 23 Apr 2008 12:19 PM PDT

On 4/23/08 4:55 PM, in article caR9absDaxw,
"com" <com> wrote:
 
Look in word preferences for auto-correct. You can exclude address book
completions.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Keyboard commands for moving cursor

Posted: 23 Apr 2008 12:18 PM PDT

On 4/23/08 3:18 PM, in article caR9absDaxw,
"com" <com> wrote:
 
Did you look in help for shortcut keys?

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Copied and pasted docs have odd spacing

Posted: 23 Apr 2008 12:15 PM PDT

<com> wrote:
 

Well it depends on where you paste in the document. If the style there
says double-line, that's waht you get. It's a "paste and adapt to local
style".

Do you get the same thing pasting in a paragraph with a style set on
single-spacing??

Corentin

--
--- Mac:MS MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs are not MS employees - Les MVP ne travaillent pas pour MS
Remove "NoSpam" to e-mail me - Retirez "NoSpam" pour m'écrire

Default document has 10 point spacing afterlines can't find a way to change this default, though i can change it in each individual document

Posted: 23 Apr 2008 12:14 PM PDT

this system is not accepting my inputs as i type them. i'll do it again

aaa
bbb

ccc
ddd

eee
fff

My mac can't view .pdf files on web nor can it print .pdf files

Posted: 21 Apr 2008 10:13 PM PDT

Glad it worked for you - Thanks for taking the time to let us know!

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 4/22/08 9:45 PM, in article caR9absDaxw,
"com" <com> wrote:
 

Deployment of Entourage 2008 by itself

Posted: 21 Apr 2008 05:08 PM PDT

Hi Alan:

Well, there are no "dependencies" as such. But the way Office is
constructed, whichever single application you install, you will get the
majority of Office installed. There is a very high level of commonality.

Each "Application" is to a certain extent just a "User Interface", and they
all use the same engine and gearbox modules :-)

However, you do not need to worry about this, provided you allow the
Installer to do the install for you. It will install all the correct bits,
regardless of what you install.

As of this moment, the file compatibility issues are NOT resolved, and some
of them are ugly!

Entourage 2008 will work well, but I would leave the other applications on
the shelf at least until the first service pack comes out :-)

Ensure that the user cannot start two versions of Entourage at the same
time, or all hell breaks loose :-) 'Rage 2008 upgrades the database, after
which 2004 can't read it :-)

So just delete the 2004 app AFTER the 2008 install to make sure they can't
start it.

Once you install the other applications, they will take over the file
associations (double-click) on the user's machine, and you cannot repossess
it. But the versions themselves will run side-by-side without a problem.
Just inform the users that if they want to open a file in the 2004 version,
they will need to start the application and then use File>Open from the
menu, or the document will open in the wrong version.

I would leave 2004 installed for the next two years at least. Your users
will need it :-)

Cheers


On 22/04/08 9:38 AM, in article
com, "Alan"
<microsoft.com> wrote:
 

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:name

troubleshooting headers and footers

Posted: 21 Apr 2008 08:05 AM PDT

> Toolbox> Formatting Palette - Header & Footer group - Link to Previous, 

'Incorrect username/password' error, even though both are correct!

Posted: 21 Apr 2008 05:23 AM PDT

Check the settings for "Secure Connection SSL". Under Receiving Options,
Advanced.

You may have it ON when it needs to be OFF.


On 21/04/08 9:53 PM, in article caR9absDaxw,
"com" <com> wrote:
 

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:name

Insert Picture fails repeatedly in Word 2008when working with labels

Posted: 19 Apr 2008 07:31 AM PDT

On 23 apr, 06:43, CyberTaz <cast.net> wrote: 

That works for my fine!!! I closed the styles section and then i could
import my pictures when it is open i can't
Thnx for this solution!!!

SNP Files

Posted: 18 Apr 2008 03:04 PM PDT

Yeah, I don't even know of a suitable alternative on a Windows box to read
..snp files, let alone anything on the Mac... And Snapshot Viewer (like most
'viewer' apps) can't save in any kind of format.

Your best bet is to get them on a Windows box, open 'em in Snapshot Viewer &
capture 'em with a good screen capture program that allows you to save in a
format of your choice. Or you may want to consider converters:

http://www.imageconverterplus.com/

And maybe:

http://www.irfanview.com/

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 4/19/08 8:06 PM, in article
microsoft.com, "JE McGimpsey"
<org> wrote:
 

uninstall MSN Messenger

Posted: 17 Apr 2008 08:33 PM PDT

On 4/22/08 4:12 08PM, in article caR9absDaxw, "cassie
hancock" <com> wrote:
 

What happens when you select the icon in the Dock and select to quit?

You can quit any application in the Activity Monitor found in Utilities.
Select the application and click on the Quit button. If the application is
hung, you can select to force quit.

--
Diane

Microsoft Works - Works 7 Calendar file

Microsoft Works - Works 7 Calendar file


Works 7 Calendar file

Posted: 09 Oct 2005 06:44 AM PDT

Hi Andy,

Am pleased to read you resolved the problem, great news, thanks for the
reply.

Ken

"Andy P" <microsoft.com> wrote in message
news:com...
| GREAT! figured it out and got it all put back where its suposed to go!
The
| problem was that it was in a hidden folder and once i worked that bit out
it
| was dead easy!
|
| thanks again!
|
| "Ken" wrote:
|
| > Hi Andy,
| >
| > Copy file mswkscal.wcd from the saved drive contents and paste it to the
| > reinstalled system.
| >
| > I have Works 6.0 on a WindowME operating system.
| >
| > The mswkscal.wcd file on my system is located C:\WINDOWS\All
| > Users\Application Data\Microsoft\Works.
| >
| > If you have Windows xp operating system the location will be different.
| >
| > Use search to find where the mswkscal.wcd file is located on your
system,
| > rename it mswkscal.old.
| >
| > Search to find mswkscal.wcd file in the saved drive contents, copy it.
| >
| > Paste the copied mswkscal.wcd file to the same location where you
renamed
| > mswkscal.old.
| >
| > Open calendar it should now have all your information.
| >
| > If all is okay, delete mswkscal.old, or keep it as backup.
| >
| > Ken
| >
| > "Andy P" <microsoft.com> wrote in message
| > news:com...
| >
| > | Thanks Ken but how on earth do i get to that information??
| > |
| > | Regards
| > |
| > |
| > | Andrew P
| > |
| > | "Ken" wrote:
| > |
| > | >
| > | > mswkscal.wcd
| > | >
| > | >
| > | > "Andy P" <Andy microsoft.com> wrote in message
| > | > news:com...
| > | > | does anybody know where the callendar file is stored. system
went
| > down
| > | > and
| > | > | have the full contents of the hard drive and just need to know
where
| > the
| > | > data
| > | > | file is saved so i can transfer it back to the reinstalled system!
| > | > |
| > | > | Andybody got any ideas?
| > | > |
| > | > | regards
| > | > |
| > | > |
| > | > | Andrew P
| > | >
| > | >
| > | >
| >
| >
| >


New here

Posted: 08 Oct 2005 05:34 PM PDT


"Habidasher" <com> wrote in message
news:net... 

Thanks! So far, no problems, and I'm on Win XP SP2. But I plan to upgrade
at some point any way.



WKGDCACH invalid page fault

Posted: 08 Oct 2005 06:02 AM PDT

Thanks for your quick reply, I'll try the articles. Jan
--
Jan


"Ken" wrote:
 

Moving Works 2000 Suite from 98 to XP Home

Posted: 06 Oct 2005 06:58 AM PDT

Ken,

You phrased my question better than I did, thank you. I should have asked,
how do I move spreadsheets/templates from one computer to another and
register them correctly.

I like your suggestion ken, I'll give it a try.

">Copying them over to a similar location on the new computer will probably 

HELP...




"Ken" wrote:
 

Works 8.5

Posted: 05 Oct 2005 09:52 PM PDT

4.5a is way better than Works 8-see some of the many posts that say
4.5 is better than v 8.x.

How do I change default working folder in Works 8

Posted: 05 Oct 2005 12:56 PM PDT

Ken wrote: 

This is one of the reasons why regular backups to an external source is
alway recommended.


--
Insert witty comment here.

Time and Formulas

Posted: 05 Oct 2005 04:46 AM PDT

Hi John,

The essential difference between the two times that you show is that they
occur on two different days! Therefore you should add 1 day to the result
from any subtraction of the two, and then the answer becomes 2 minutes.

Times alone are not fully declared values until they also possess a DATE
attribute (days past since Dec 31st 1899)

See for yourself:

In cell A1, type the TIME value 23:59

In cell B1, type the TIME value 00:01

In cell C1, type the formula = 1 + B1-C1
which gives the answer, in DAYS, of 0.0013889.

To see this as HOURS, in cell D1 place the formula = C1*24
which gives the answer, in HOURS, of 0.0333333

For MINUTES, in cell E1 place the formula = D1*60
which gives the answer, in MINUTES, of 2 ( Use ROUND, if necessary).

Or,

You could place this formula in Cell C1, to directly calculate the
difference,
in minutes, between two start and finish times ( less than 24 hours
apart ).

=((B2<A2)+(B2-A2))*24*60

The TRUTH statement (B2<A2) determines whether the times span across
two days, and adds 1 day if they do.

Use the fully delared time ( Date + Time ) to calculate difference over a
number
of days.

Again,

In A1, type a date, say 1/1/2001
In B1, type a time for that day, say 08:57

In C1, type a date. say 2/2/2002
In D1, type a time for that day, say 06:23

Now,
In E1, type the formula = A1+B1, giving 36892.373
In F1, type the formula = C1+D1, giving 37289.266

In F1, type the formula = (F1-E1)*24, giving 9525.4333
This is the number of hours and part hours separating the two instances.

=INT(G1) shows the number of whole hours that have past, 9525
=MOD(G1,1)*60 shows the MINUTES value to be aded to the whole
hours, this is given as 26 minutes.

Therefore,the difference is 9525.433 hours or 9525 hour and 26 minutes.

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2006
Works Help & KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"yoingco" <com> wrote in message
news:com...
| Hi Kevin,
|
| 2 nil to wales as I speak ;)
|
| So how would I do 23:59 to 00:01 so I get the answer 2 minutes??????
|
| Regards
|
| John
|
|
|
| "Kevin James - MSMVP Works" wrote:
|
| > Hi John,
| >
| > Times entered in a time format can look after themselves
| >
| > i.e 13:15 and 15:09
| >
| > where, 15:09-13:15 = 0.0791667 (days)
| >
| > If this is then multiplied by 24 you get the value in HOURS which is
1.9
| >
| > HOURS value can be extracted using INT(1.9) giving =1
| >
| > MINUTES value can be extracted using MOD(1.9,1)*60 giving =54
| >
| > STRING helps you create different "formats" by casting and concatenating
| > values into strings.
| >
| > i.e 1 Hours 54 Minutes
| >
| > using =STRING(Hrs,0)&" Hours "&STRING(Mins,0)&" Minutes"
| >
| > where Hrs and Mins are cells holding the repective values for
concatenation.
| >
| > Alternatively you may form 1:54 using =STRING(Hrs,0)&":"&STRING(Mins,0)
| >
| > HTH,
| > --
| > Kevin James.
| > Tua'r Goleuni
| > Microsoft MVP (Works) 1999-2005
| > Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
| >
| >
| >
| >
| >
| > "Homer J Simpson" <com> wrote in message
| > news:XIx1f.11585$..
| > |
| > | "yoingco" <com> wrote in message
| > | news:com...
| > |
| > | > One question though. I noticed that if the seconds are in cell A (i.e.
| > | > 13:15) are more than the seconds in cell B (i.e. 15:09) i get a result
| > | > of -6
| > | > for the seconds total. So do I have to use the IF function to first
detect
| > | > if
| > | > B is greater than A, less than A and so on? And what about calculating
| > | > backwards in general?
| > |
| > | Possibly use ABS() ??
| > |
| > | Can you give a line from your sheet?
| > |
| > | N
| > |
| > |
| >
| >
| >
| >
| >



Will VLookup look over it's shoulder?

Posted: 05 Oct 2005 02:21 AM PDT

G'day Kevin,
the obvious flew into my face, just after I posted.
I just added a column on LHS
with the formula "=E1"
which copies the out of order column into place

I just paste the block into cell B1 voila!

I thought having two instances of the same name
in two columns may cause conflict, but it works like a charm.

Cheers, friend.



--
rodney at touch88.com.au

Send spam to the FTC at
gov
Thanks, robots.



"Kevin James - MSMVP Works" <org> wrote in message news:phx.gbl...
| Hi Rodney,
|
| Honestly, no rib tickling intended ;-)
|
| Is the order of the columns fixed?
|
| In situations like this, where a touch of automation could help
| to remap the columns I would perhaps seek out a 'macro recorder'
| type program to create a utility file for post processing, retaining the
| original structure in my backup file(s).
|
| If you care to send me a few tuples then I'll see if I can sense an
| alternative method.
|
| HTH,
| --
| Kevin James.
| Tua'r Goleuni
| Microsoft MVP (Works) 1999-2005
| Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
|
|
|
|
|
| "Rodney" <com.au> wrote in message
| news:phx.gbl...
| | Ouch!
| | I felt that dig in the ribs :)
| |
| | Yes, I am aware of the "Help File"
| | however this program, (and the Gurus who manipulate it)
| | present company included,
| | often have a way to hurdle the rules, and objectives are met with
| | surprisingly nifty weapons, seems this time the answer is in the negative,
| | however I shan't die wondering :)
| |
| | Homer,
| | the data I dump into the SS, as the reference material, is proprietary
| | and about 8000 or so rows long.
| | I have been successful pasting the data into the start column B
| | then pasting a copy of column d into A, which meets the objectives
| | albeit with a further number of processes.
| |
| |
| | --
| | rodney at touch88.com.au
| |
| | Send spam to the FTC at
| | gov
| | Thanks, robots.
| |
| |
| |
| | "Kevin James - MSMVP Works" <org> wrote in message
| news:phx.gbl...
| || Hi Rodney,
| ||
| || Found in the Works 8 Help file :-)
| || VLOOKUP(LookupValue,RangeReference,ColumnNumber)
| || "The VLOOKUP functiona built-in calculation that you
| || can use to create a formula searches the first column of
| || RangeReference until it finds the number that matches
| || LookupValue. Then it searches to the right by the number
| || of columns indicated by ColumnNumber, and gives the
| || value (text or number) it finds.
| ||
| || The offset (column) must be positive, therefore Works will
| || not look to the left, behind the VLOOKUP column.
| ||
| || Alternatively, you could copy and past column B to the right
| || of column C.
| ||
| || HTH,
| || --
| || Kevin James.
| || Tua'r Goleuni
| || Microsoft MVP (Works) 1999-2005
| || Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm
| ||
| ||
| ||
| ||
| ||
| || "Rodney" <com.au> wrote in message
| || news:%phx.gbl...
| || |
| || |
| || | Say I have 8 columns, A thru H
| || | the lookup table is column C
| || | Can Vlookup find the match in C3501, and report the
| || | resultant number residing in B3501?
| || |
| || | ...or do I cut and paste column c to column a?
| || | which would be a pain in the botty.
| || |
| || | Thanks
| || |
| || |
| || |
| || | --
| || | rodney at touch88.com.au
| || |
| || | Send spam to the FTC at
| || | gov
| || | Thanks, robots.
| || |
| || |
| || |
| || |
| || |
| ||
| ||
| ||
| |
| |
|
|
|


Calendar - Holidays

Posted: 04 Oct 2005 02:03 PM PDT

Add Holidays no longer exists in Works 7

The above information found by searching this news group at google.

http://groups.google.com/group/microsoft.public.works.win/search?group=microsoft.public.works.win&q=add+holi day+missing&qt_g=1&searchnow=Search+this+group


"Todd Gibbs" <microsoft.com> wrote in message
news:com...
| I am trying to add Holidays to my Works (version 7.0) Calendar program. I
| have clicked on EDIT but can not find HOLIDAYS to add them. That function
| does not appear to be available... any suggestions? Am I missing
something?


Access formula

Posted: 03 Oct 2005 02:40 PM PDT

Yes that works fine.
thank you
Karen

"Homer J Simpson" wrote:
 

Works 8.0 Calendar problem

Posted: 03 Oct 2005 02:12 AM PDT

I got it working!!!

Thanks for the lead, Eric. In my case, the wkcalcat.dat file was ok, but I
noticed that the CalMRU.dat file was suspiciously small at 0k. So I just
decided to delete CalMRU.dat. Then I tried to launch Calendar again, and hey
presto, everything works fine again. MSWorks automatically created a new
CalMRU.dat file of size 1k.

"Erik Jan" wrote:
 

Works 7.0 Word loads but unable to enter text

Posted: 01 Oct 2005 01:07 PM PDT

Thanks for all you help Ken. I have no idea why changing the mouse thing
worked and I hope it continues -- but I learned some new things in the
process about templates and uninstalling/reinstalling programs. Kevin
"Ken" wrote:
 

My Works 8 Keeps Installing In A Different Language!!!

Posted: 01 Oct 2005 09:30 AM PDT


"Tomzilla" <microsoft.com> wrote in message
news:com... 
 

All I can suggest then is to try to make a CD copy of the installl disk and
remove unneeded languages or tinker with the install script. I assume
you'vve searched microsoft.com

Attached are the files from an English only version. Not sure they'll show
up here though.

N

=============
SETUP.INI
=============
[Logging]
Type=icewarmup
Path=%TEMP%
Template=WksSetup(*).txt
=============
AUTORUN.INF
=============
[autorun]
open=MSWORKS\autorun.exe
icon=MSWorks\autorun.exe,0
=============
README.TXT
=============

------------------------------------------------------------
README for Microsoft Works 8

------------------------------------------------------------

(c) Copyright Microsoft Corporation


For the latest information on Works, visit our Web site at
http://www.microsoft.com/products/works, or, to access the Web site
from within any Works program, on the Help menu, point to
Microsoft on the Web, and then click Online Support.


========================
HOW TO USE THIS DOCUMENT
========================

To more easily view this document, maximize the Notepad window.

To print this document, click Print on the File menu.


========
CONTENTS
========

Installing Microsoft Works
Issues
Files Written to the Windows System Folder
Templates Saved to the Program Files Folder
Frequently Asked Questions


==========================
INSTALLING MICROSOFT WORKS
==========================

To install Works:

1. Insert the Works CD-ROM into your CD-ROM drive.
Setup starts automatically.
2. Follow the instructions on your screen to install Works.

If Setup does not start automatically, do the following:

1. On the taskbar, click the Start button, and then click Run.
2. In the Open box, type the letter of your CD-ROM drive followed
by a colon (:), and then \msworks\setup.

For example, if your CD-ROM drive letter is d, type d:\msworks\setup.


======
ISSUES
======

When using Windows 98 Second Edition, your computer may not shut
down properly after you install Works 8. To fix this, install
the update available from the following Web site:

http://www.microsoft.com/windows98/downloads/corporate.asp

Click the "Windows 98 Second Edition Shutdown Supplement"
link and follow the instructions on the screen
to download and install the update.

------------
Sending E-mail From Within a Program

With certain operating system configurations, Microsoft Outlook
Express does not properly configure Messaging Application
Programming Interface (MAPI) when it is installed. Applications
may stop working when you click the Send command on the File menu.

Solution:

1. Double-click the Outlook Express icon on the desktop.
- or -
On the taskbar, click the Start button, point to Programs,
and then click Outlook Express.
The Internet Connection Wizard appears.
2. Follow the instructions.

This properly configures MAPI.

------------

Printing Word Processor Templates

Certain printer drivers may not print some Word Processor templates
correctly.
Although the document may appear to be correct when you click Print
Preview on the File menu, it looks different when you print. For example,
the printed version may be formatted differently from the original, the
document may print on more than one page, or a blank page may appear at
the end of the print out.

This problem occurs with these and other drivers:
* HP DeskJet: 2500, 680c, 692c, 1600, 670c, 660c
* HP LaserJet: 2600, 4mv, 8550, 4500

To fix this problem, you must adjust the margins manually for the document.

1. On the File menu, click Page Setup.
2. If it isn't already selected, click the Margins tab.
3. Adjust the settings so the document prints as you want it to.

------------

Setting Up Synchronization Between Palm Devices and Handspring(tm) Visor
Devices

If you are using Windows 2000 SP3 or later, you must install the latest
version of Palm Desktop to synchronize Palm devices with Handspring(tm)
Visor
and Visor Deluxe. You can download the latest version from the
Handspring(tm)
Web site.

For more information or to download software, contact Handspring
Support at http://support.handspring.com.


=============================================
Files Written to the Windows System Directory
=============================================

The installation of Works will result in the following files
being written to the Windows System or System32 directories:

LeadTools image import filters:
lfcmp11n.dll ltdis11n.dll lfpng11n.dll
ltwvc11n.dll pcdlib32.dll lfbmp11n.dll
lfeps11n.dll lffax11n.dll lfgif11n.dll
lfpcd11n.dll lfpcx11n.dll lfpsd11n.dll
lftga11n.dll lftif11n.dll lfwmf11n.dll
ltfil11n.dll ltimg11n.dll ltkrn11n.dll

Macromedia Flash:
Macromedia Flash files are written to the "Macromed" sub-directory.

Additional files:
hlp95en.dll mfc42.dll mfcans32.dll
msls2.dll msvci70.dll msvcp70.dll
msvcr70.dll ochlp30e.dll pubole32.dll


==============================================
Templates Saved to the Program Files Directory
==============================================

The Works Spreadsheet and Works Database will save
any user created templates to the Works installation directory.
By default, this directory is c:\Program Files\Microsoft Works\Template.


==========================
FREQUENTLY ASKED QUESTIONS
==========================

A. Why do the templates I created using earlier versions
of Works not show up after I upgrade?
B. How do I set up Works 8 on my computer without removing
Works 2000?
C. Can I install individual programs from Works 8?
D. Why can't I find my files from Works 4.5a or earlier?
E: Do I have to convert my existing Works files after I install
Works 8?
F: After I upgrade to Works 8, can I share files with people
using earlier versions of Works?
G: If I remove a program from the Works Task Launcher, how can
I get it back?
H: While using Works, some of my toolbar buttons appear as
blank boxes at the top of the screen. How can I fix this?

------------

Q: Why do the templates I created using earlier versions
of Works not show up after I upgrade?

A: You need to upgrade your existing templates.

1. On the taskbar, click the Start button, point to
Programs, and then click Microsoft Works.
2. In the Works Task Launcher, click the Programs tab.
3. Click the program in which your Works templates
were created (ie: Word Processor, Spreadsheet, or
Database).
4. Click Start a Blank <program name.>
5. On the File menu, click Open.
6. Switch to the drive or folder where the template
is located and double-click the template name.
The default location for templates created in
Works 2000 is:
C:\Program Files\MSWorks\Template
The default location for templates created in
Works 4.5a or earlier is:
C:\Program Files\MSWorks\Documents.
7. On the File menu, click Save As.
8. In the Save As dialog box, click Template.
The Save As Template dialog appears.
9. Type a name for the template, and click OK.
Works 8 saves the Works Word Processor template you created in:
C:\Windows\Application Data\Template
Works 8 saves the Works Spreadsheet and Works Database template you
created in:
c:\Program Files\Microsoft Works\Template

------------

Q: How do I set up Works 8 on my computer without removing
Works 2000?

A: Microsoft recommends not to run different versions of
Works on the same computer. Works 8 will automatically
remove any older versions of Works when you install Works 8.

------------

Q: Can I install individual programs from Works 8?

A: No. Due to the high level of integration offered in
Works 8, all of the standard programs (Database,
Calendar, Word Processor, Spreadsheet, Portfolio,
and Works Task Launcher) are installed together.

------------

Q: Why can't I find my files from Works 4.5 or earlier?

A: The files may be stored in a folder other than the one in
which you are looking.

In Windows XP Professional or Home Edition:

1. On the taskbar, click the Start button and click on
Search.
2. Click All files and folders.
3. In the All or part of the file name box, type all or
part of the file name you are looking for.
4. Click Search
5. Double-click the file name.

In Windows 2000 Professional, Windows Millennium Edition,
or Windows 98 Second Edition:

1. On the taskbar, click the Start button, point to Find,
and then click Files or Folders.
2. In the Named box, type all or part of the file name
that you are looking for.
3. Click Find Now.
4. Double-click the file name.

NOTE: For Works 8, Works 7.0, Works 6.0 and Works 2000,
the default directory is My Documents. The default directory
for previous versions of Works is
C:\Program Files\MSWorks\Documents.

------------

Q: Do I have to convert my existing Works files after I
install Works 8?

A: No. You do not need to convert your Word Processor,
Database and Spreadsheet files created in Works 4.0 or later
to another format to open them using Works 8.

The information in your existing Works Calendar will be
automatically upgraded to Works 8.

You do not need to convert your Address Book from Works 2000
or later to use it with Works 8.

Microsoft recommends that you convert your address book
from Works 4.5a or earlier version to the new Address Book. By
moving your old address book information to the Address Book,
you can access your data not only from the Word Processor
but also from the Calendar and Outlook Express.

To convert your address book information from Works 4.5a or earlier
to the new Address Book:

1. On the taskbar, click the Start button, point to
Programs, then click Microsoft Works.
2. In the Works Task Launcher, click the Programs tab.
3. Click Address Book.
4. Click Address Book converter.
5. Click Start.


------------

Q: After I upgrade to Works 8, can I share files with
people using earlier versions of Works?

A: Yes.

The Works Word Processor and Spreadsheet let you
save files in the formats that earlier versions of Works support.
To save a file in an earlier Works format,
1. From within the program, click on File menu,
2. Click on Save As...
3. In the dialog that oppears, select the file format you want to save in.

This is the recommended way to save a spreadsheet
or word procesor document for use in Works 4.x/2000 formats.
Word processor documents may lose some formatting when
saving as an earlier Works format.

You can also open a Works 8 spreadsheet directly in
Works 2000, but you need to complete the Import Excel
Spreadsheet dialog. Your charts and formatting will not
be preserved.

You can directly open Database files created in Works 8
in earlier versions of Works.

------------

Q: If I remove a program from the Works Task Launcher, how
can I get it back?

A: If you removed a Works program such as the Word Processor,
Spreadsheet, Database, or Calendar, you must reinstall
Works for it to appear in the Works Task Launcher.

For Microsoft Suite programs such as Microsoft Money,
Microsoft Encarta, or Microsoft Picture It, reinstall the
Works Suite. Make sure you select the Express Full option
to automatically install all Works Suite programs.

------------

Q: While using Works, some of my toolbar buttons appear as
blank boxes at the top of the screen. How can I fix this?

A: This is a known issue with machines that have a 3D ATI
Rage Pro Video Card installed, however this problem may
occur on machines with other video cards installed as well.
To remedy this problem you must turn off the hardware
acceleration on your video card.

Follow these steps to disable your hardware acceleration
on Windows 98 Second Edition, Windows Millennium
Edition or Windows 2000:

1. On the taskbar, click the Start button, point to
Settings and then click Control Panel.
2. Double-click the Display icon.
3. Click the Settings tab.
4. Click the Advanced button.
5. Click the Performance tab.
6. Next to Hardware acceleration, point to the slider
and then click and hold the mouse while you drag the
slider as far to the left as it will go. It should
appear next to None.

Follow these steps to disable your hardware acceleration
on Windows XP Home or Professional Edition:

1. On the taskbar, click the Start button, and then click
Control Panel.
2. Click Switch to Classic View on the sidebar if you're
in Category View.
3. Double-click the Display icon.
4. Click the Settings tab.
5. Click the Advanced button.
6. Click the Troubleshoot tab.
7. Next to Hardware acceleration, point to the slider
and then click and hold the mouse while you drag the
slider as far to the left as far as it will go. It
should appear next to None.

NOTE:

When you engage in other tasks that will require
hardware acceleration, such as playing games,
repeat the steps above to restore the hardware
acceleration back to Full. Failure to do so will
result in poor game display performance.



Works 8.0 Calander Error on opening

Posted: 01 Oct 2005 12:06 AM PDT

Thanks for the tip, Kevin. I downloaded the MDAC checker program from the
link you provided, but everything checked out ok with MDAC.

I got it fixed by deleting the CalMRU file in C:\Documents and Settings\All
Users\Application Data\Microsoft\Works folder.

Maybe if you come across anyone else with this problem, if none of the other
standard resolutions are effective, and if their CalMRU file is 0kB, they
might try deleting it (or backing it up by moving it to a different folder)
and launch Calendar to see if that works.

"Kevin James - MSMVP Works" wrote:
 

Print and Crash

Posted: 28 Sep 2005 03:26 PM PDT

> Works 8 seems to have printer issues that Word 2000 does not. I suspect
the 

There's something wrong in the file.. if i print from another file, the
print is successiful..

--
Cià
"Homer J Simpson" <com> ha scritto nel messaggio
news:Vnf0f.324606$..