Hate having to press save just to update cells
I am not sure how this happened. I have been working in the same file
for a long time but now all of the sudden, cells won't update until I
hit save. Is there a way to fix this. I have a huge file and it is
such a pain to wait 10 seconds every time I want to see the calculation
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
Check if your calculation is still set to auto.
<Tools> <Options> <Calculation> tab,
Make sure "Automatic" is checked under...STUCK in "Update in Progress"
Anyone know how to get M05 out of this?
I've deleted IE cache and \temp directories with no avail!
...Charts that are Off-Screen Disappear after update
I have a sheet in a Workbook that holds about 21 charts. When I add data to
the workbook, I need to go into every chart and add rows to each data series
as well as the Horizontal Axis. Since this is tedious, I wrote a Macro to do
this. The Macro works great...but when I run it, any chart that is off-screen
disappears. It still exists, but the only way I can make it visible again is
to save the workbook, close it, and reopen it. I have tried to refresh the
graphs as I update them, but that hasn't fixed it.
The only fix that I have found that works is to temporarily set the Wi...How do I get rid of blank pages in a report?
Could anyone tell me how to have my report print only where there is data and
not to print out blank pages?
On Tue, 5 Feb 2008 14:27:18 -0800, SIRSTEVE wrote:
> Could anyone tell me how to have my report print only where there is data and
> not to print out blank pages?
> Thank you.
Code the Report's OnNoData event:
MsgBox "There are no records to print."
Cancel = true
If you opened this report from an event on a form, this will raise
error 2501. Trap the error in the form's event that opened the report.
On Error GoTo Err_Handler
DoCmd.OpenR...Print 2 pages on one page...fill both halves
I am trying to print 2 pages on one page, but I want each page's print area to fill the entire half of the printed page. I can get 2 pages to print on one page, but each page shows up pretty small on each half of the printed page. I've tried many different combinations (fit to 1 page wide and 1 page long, etc...) for each of the pages, but nothing seems to correct the issue I'm having. Any suggestions? Thanks in advance!!!
Take a picture of each page and paste them on a new sheet and print it.
Select the first area to print then...
Hold down the shift key and click the Edit menu....Purpose of Data Access Page?
I hope this doesn't seem like a stupid question. What is the purpose of a
data access page? It seems to me you can accomplish a whole lot more with
forms. Data access pages have many limitations. What would be an example of
when you would want to use a data access page over a form?
Forms: PC use
Data Access page: Web use
"REGREGL" <REGREGL@discussions.microsoft.com> wrote in message
> I hope this doesn't seem like a stupid question. What is the purpose of a
&...30-page newsletter suddenly changed!?
Am using Publisher 2003, have done many, many newsletters but never
experienced this b4. Changed font from a previously used advt from earlier NL
to another font, changed leading from 1.14 to 1 - and now ALL 30 pages have
changed to franklin gothic demi, 1.14 spacing!
Any suggestions, anyone, please as to how to return publication back to what
Have the horrible thought I am going to have to redo 3 days work of
Create a font scheme to match what you had before. Apply to a text box, select
the box, double-click the Painter tool, scroll th...RW-Page Break on Calc Field
Does anyone know if it's possible to create a page break on a calculated
field in the RW section options (or any other method)?
I am modifying the PM History Dist. Detail report. I have concatenated
Account Segment 2 and 3 and the combination of the two reporesent cost
My report works nicely, but I can't get a break (lol).
Thanks in advance.
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
...OL2000: Selecting "send page by e-mail" or "send link by e-mail" in Internet Explorer locks Outlook until message is sent
In Internet Explorer: File -> Send -> Page by E-mail / Link by E-mail. This will open a new message in Outlook. However, the user cannot leave this message open and do other work in Outlook - Outlook behaves as if this new message was a dialog box. This is very annoying.
On another note, when selecting the "Page by E-mail" option, Outlook creates a .htm attachment of the web page when plain text is set as the default mail option instead of creating a HTML message. Outlook should let the user choose. Outlook Express creates a HTML message in this case.
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Ok. I�ve tried everything. I have a legal, registered copy of 12.1.0,
running on a Macbook Pro running OS X 10.5.6, but try as I might I cannot
update to 12.1.5. The update process, after downloading this massive �patch�
fails to find a legal copy of my software! (I am writing this on Entourage,
which crashed once already during writing this)...Web Pages appear distorted
I am attempting to put together a small website on my new computer using
Publisher 2003 SP2. However, I am experiencing problems when attempting to
preview it on said computer (using Web Page Preview). The text and graphics
look completely out of place.
Yet when I preview it on another computer, it looks exactly like the way I
intended it to be (i.e., WYSIWYG).
I am not sure if the laptop I am using is the problem. It's a Dell Inspiron
E1505 laptop computer with a 15" widescreen display, 1 GB RAM and a 1.8 GHZ
Dual Core CPU.
Any help is appreciated. Thanks,
I downloaded and installed MS update KB980182 and now the computer runs a lot
slower when I am using Internet Explorer. I have done everything I can think
of to rectify the problem but it does no good. When I unistall the update, IE
runs at its
normal speed and when I reinstall it, the problem returns, therefore it has
something to do with this update.
Does anyone else have this problem or have a solution to this problem?
"Ward" <Ward@discussions.microsoft.com> wrote in message
>I downloaded and in...2004 Stock Updates Expired?
This is a multi-part message in MIME format.
Running Money 2004 Deluxe - recent system rebuild and application =
Just noticed that my stock prices have not updated since 9/1/06 - but my =
direct banking downloads have continued to update.
Have I run into the 3 year download expiration - w/o receiving any =
Last I read, I thought the service would expire in January.
They must have my system key flagged from the date of initi...Update Column with Restricted Collation?
SQL Server 2008, server and database are both set to default Latin CI
collation. Some characters are in there that are not valid for
consuming systems. I would like to write a SQL-Update that will
replace the varchar value with a value with a "restricted collation"
like ASCII 7-bit so characters not on a standard US keyboard will be
How can I do that?
On 2010-04-13 22:01, SnapDive wrote:
> SQL Server 2008, server and database are both set to default Latin CI
> collation. Some characters are in there that are not valid for
> consuming syste...Make a change to an Update Query
I need to make changes to an update query but when I open the desing view it
only shows the field that being updated. How do I view the hidden fields?
Answered in your prior post
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
> I need to make changes to an update query but when I open the desing view it
> only shows the field that being updated. How do I view the hidden fields?
...Possible solution to .NET Framework Updates
Like many of you, I have been grappling with unsuccessful .NET Framework
updates. Hopefully, this post might help you. I am operating from Windows XP
Home Edition SP3 - 32bit. What I did...
From Control Panel - Add And Remove Programs, I removed .NET Framework 1.1
(it had SP1 on top) NOTE: Add and Remove Programs would NOT allow me to
remove .NET 2.0 SP2 or 3.0 SP3. I DID NOT USE THE WINDOWS UNINSTALL CLEAN UP
UTILITY. I attempted to uninstall .NET 3.5 SP1 and it allowed me to do so.
The program asked if I wanted to Uninstall or Repair the program. I SELECTED
T...Merge 3 Xls worksheets updates into master xls
I have several xls spreadsheets that all have the same columns, I want to
merge updates in three xls spreadsheets into another spreadsheet which is my
master thus updating the master with data from the three other xls files. Is
there a software program out that does this? Or a command I can use that will
...hyperlink filename #
Is there a way or trick or workaround to generate a hyperlink in a cell which
points to a file which happens to contain a "#" (pound) in its filename?
I've always changed the filename.
> Is there a way or trick or workaround to generate a hyperlink in a cell which
> points to a file which happens to contain a "#" (pound) in its filename?
This morning, on both my laptop and desktop using IE8 8.0.7600.16385,
certain stories on smh.com.au "disappear" after a few seconds. It also
occurs in the online version of theage.com.au, part of the same group. I
downloaded Firefox and there is no problem.
It seems unlikely IE could have been corrupted on both machines. Is there
some add-on I need?
Tools> uncheck InPrivate Filtering
"Bill" <firstname.lastname@example.org> wrote in message
> This morning, on both my la...Bad certificate on MS Windows Update sites
I pulled up the following MS site via IE 8 - Version 8.0.6001.18702 - Build
I received the error message:
There is a problem with this website's security certificate
The problem is I had just 'updated' my Microsoft Trust Certificate
via the process.
1. In Control Panel, open Add or Remove Programs
2. Click Add/Remove Windows Components.
3. Select the Update Root Certificates check box.
4. Click Next, and then click Finish.
So I have the following questions.
 Is there...Can you have more than one hyperlink in a cell in Excel?
If you can have more than one hyperlink in a cell - what do you separate the
> If you can have more than one hyperlink in a cell - what do you separate the
> hyperlinks with?
You could cheat and add rectangles over the words/phrases you want. Then hide
the borders and assign a hyperlink to each of the rectangles.
You could even format those characters (if the value in that cell is not a
But it can be a ...Align object on back of page
I am making a gift tag with publisher using cardstock. I want a picture on
front. On the inside needs to be To: / From: Like a greeting card only much
smaller. My problem is that I cannot find a reliable way of alinging the front
and back. Is there a simple way of knowing where to place the graphics and text
inside. I tried the greeting card but it is far too big. Of course the 4 fold
won't work either.
If you want them all alike, setup one of the label templates and insert another page
for the back. When you go to print, print current page, turn the card stock over and
print the second...first page of brochure from other papertray?
Is there a workaround in MSPUB 2003 for printers that don't support the
function: 'take first page from tray X' and 'the rest of the pages from tray
Y' on 1 printjob.
I like to print an A4 doublesided brochure using a heavier papersort for the
I know MSWord can do this using sections.
I like to replace and old HP color laserjet which does support this in the
Windows printerdriver, with an Epson Aculaser which don't.
Create a new publication for the cover. If your printer doesn't support a different
paper for the first page this probably is the only worka...Publisher 2003 Extra Blank Pages
Publisher Version 2003
I have a 12 page document that I have used for 7 versions of a
newsletter without any problems. I open up the previous one, delete
the content, save with a new name and start again. However, it has now
started to print an extra blank page after each page with content.
These blank pages do not show up in the document but only when I use
Print Preview, Print to a printer or try to create a pdf. I have tried
to print to different printers with the same result. The document is a
simple 12 page document. ie not a booklet. I can get around it
temporarily by printing ...Window XP Update
I have an HP m7480n computer 3.0GHz, 2.00 GB RAM expandable to 4.00 GB and
280 GB of hard drive , NVIDIA GeForce 7300 LE video card ect .... I bought
it about 2 years ago and since then i had quit a few problem. Last fall the
manufactor had to replace the mother board and power supply , i had to format
the drive in january because of a virus and two days ago i had to do the same
again .... talk about bad luck ... lol . I have done all the update that
needs to be done from HP and Microsoft and my system is working fine now
except for one issue ... there is an update that d...