Row limits with Publisher
Is it possible to exceed publisher table limit of 128 rows? I have a
spreadsheet that I want to import with almost 2,500 rows. Thank you in
advance for your assistance!
> Is it possible to exceed publisher table limit of 128 rows? I have a
> spreadsheet that I want to import with almost 2,500 rows. Thank you in
> advance for your assistance!
Given that Publisher can't flow tables across pages, that's going to
have to be a really long page!
(I don't have an answer for your question.)
Ed Bennett - MVP Microsoft Publisher
http:...how do i cancel user restricted values in a cell
Gord Dibben MS Excel MVP
On Thu, 14 Aug 2008 08:58:07 -0700, grahamcotton
I notice that in Excel 2003 you can protect a sheet but have an option that
would continue to allow rows to be inserted. Is there a way to do this in
Excel 2000? When I protect the sheet then row inserts are no longer
Thanks for any help.
Disclaimer: Any comments made are personal and do not reflect the thoughts
or policies of this company.
You can insert the rows with a macro, as long as the macro
turns off protection. You do not need a password for protection
but if you do, then the macro would have to use that password.
For macros to insert rows see
...Finding a string in Excel cells
Not sure if this is an Excel problem or a general Microsoft products
"feature", but here goes:-
I've inherited a HUGE spreadsheet with 6 figures of cells in total(!)
and I'm told that some have been highlighted for query or error with
"???" in the cell (in addition to other text in that cell).
Trouble is, as soon as I do "find" with the "?" character, it seems to
ignore it, as if ? is some reserved character.
Does anyone have any idea how I can get round this?
The ? character is used as a wild card character (any single character).
...Change scroll rows from 1 to 3 with mouse wheel
Does anyone know how to set the mouse scroll amount from 3 rows to 1 row in
Excel 2007? There used to be an option in 2003, but I can't find one in 2007.
It is set in Mouse in the Windows Control Panel
> Does anyone know how to set the mouse scroll amount from 3 rows to 1 row in
> Excel 2007? There used to be an option in 2003, but I can't find one in 2007.
...Row formatting based on cell content #2
That didn't turn out the way i had hoped to explain what i get in m
files....but if you can imagine a space in the first colum where
DBT120 D-LINK Bluetooth USB Adapter
DCF650BT D-LINK Bluetooth PDA Compact Flash
CABLE - SURGE FILTER
SF001NP SURGE FILTER PC POWER CABLE
CABLE - IDE HDD/CD ROM
AUDCAB AUDIO CABLE - BLACK TO BLACK
IDECAB IDE DATA CABLE (HDD/CD ROM) - 3 drop
IDECAB133 IDE DATA CABLE -ULTRA ATA 133 (HDD)
CABLE - NETWORK
CABUTP005 0.5 METRE UTP RJ45 LEVEL 5 NETWORK CABLE
CABUTP01 1 ...cascade copy?
Is there such a thing as a cascade copy? I know there's cascade delete where
if you delete the main record, all related subrecords are deleted but what if
I want to do the reverse. For example I have a quote that has subpackages
related to it. If I want to copy the main quote, I want all related
subrecords copied along.
Or is this a programming thing?
"Alan" <Alan@discussions.microsoft.com> wrote in message
> Is there such a thing as a cascade copy? I know there's cascade
...Insert / remove a row from protected sheet excel 2003 #2
I have my worksheet protected. I set the frist 5 rows all cells to Locked.
The rest of the cells are Unlocked.
When applying protection I ticked the boxes saying allow insert of row and
allow delete rows.
Yet when the protection is applied the icons / menu options for inserting /
deleting rows are grayed out. What am I doing wrong? Thanks!
...what is the attribute name for this : "automatically update e-mail addresses based on email-address policy"
There is a check box above for the exchange 2007 console.
What is the equivalent of the attribute name ?
"IT STAFF" <email@example.com> wrote in message
> There is a check box above for the exchange 2007 console.
> What is the equivalent of the attribute name ?
...Place a form control value in Access to a specific cell in Excel.
I didn't get a response on my last post, so I'm hoping someone will
have an idea on this request. Below is my original post:
Hi, All! I'm looking for some help in moving data from my Access
to specific cells in an Excel template. I'd like to create a command
button on my Access form that will open the .xlt file and transfer
some of the values on my form and plug them into the .xlt. For
example, I have the cost of equipment calculated on my form control
printers @ $300 each = $900), the command button will capture that
value and plug it into the capital expenditure ...Top row of excel stays even in sorting
I need a header in the top row of my excel worksheet so that even when I sort
the data the top row remains the same.
Data>>Sort>>My Data Range As>> Check the “Header Row” Option Button.
Press Alt+D+S the Sort Dialog Box will appear Press Alt+H which will select
the “My Data has headers” check box.
Remember to Click Yes, if this post helps!
> I need a header in the top row of my excel worksheet so that even when I sort
> the data the top ro...cell comment
how can i copy the cell comments from one workbook to another. i have no
trouble coping comments to a different part of same workbook.
Try: Copy > Paste special > Check "Comments" > OK
(Just tried it. It works within the same book, and to another book as well)
Use xdemechanik <at>yahoo<dot>com for email
"bob" <firstname.lastname@example.org> wrote in message
> how can i copy the cell comments from one workbook ...Hidden Recipients show up in query-based distribution group
I have several recipients that I have hidden from the GAL because they have
left the company, but they still show up in the Preview tab of our
query-based distribution groups.
Does anyone have a solution to this problem??
modify the ldap query to exclude recipients with msExchHideFromAddressLists
attribute (set to true)... ?
"DaveF" <DaveF@discussions.microsoft.com> wrote in message
>I have several recipients that I have hidden from th...Create separate chart for each row in excel
I am attempting to create a separate chart for each row of my worksheet
(about 300 rows = 300 separate charts). Is there an easy way to do this?
The actual data range will change month-to-month, so I would not want to
have to recreate 300 new charts each month individually.
While I have never created (or tried to create) 300 charts in a single
workbook, it is easy to believe that performance and stability of Excel
might become a question.
Do you have to have 300 charts? Or will one chart (or a few) that can
be easily changed to reflect new data suffice? If so, adapt the ideas
Using Win XP Pro with Office 2000 Pro SR-1 (all Office and Win XP
Having major problems with Outlook 2000 locking up. When I am unable to
get into Outlook I then go into Ctrl+Alt-Del and look at the processes.
Here I can find up to SEVEN versions of Outlook.Exe running, as well
as a few WinWord.Exe (use HTML and Word as editor). Meanwhile Outlook
will not open until I remove all these processes from the list. Then it
opens after a 1-minute hard drive delay. Often Outlook will be running
but not visible (tied up in the background I think). If I were ...00/01/1900 In the date cell when linked cell is empty?
Hi I have 52 worksheets all linked up to a total sheet that is working very
well thanks to RD
All I need to do now is sort out the date this is copied from sheet1 onto
the totals page and works fine when the date is put into sheet1.
However if the cell is blank on sheet2 the date is put into the totals sheet
as 00/01/1900 when the date is put in sheet2 all is well with the right date
entered into the totals sheet.
So how do I get the totals date to stay blank until the weekly sheets have a
date put into the sheet please.
the format I am using is below
many thanks for all the help I ...Combining cell with the & function and keep the individual cell fo
Is there a way to keep the original format of the cell when combining the
cells together? For instance, my formula is =c4&" "e4. I would like c4 to
be bold, but not e4.
Is this possible?
this is not possible with formulas
"Kelly Ma" <Kelly Ma@discussions.microsoft.com> schrieb im Newsbeitrag
> Is there a way to keep the original format of the cell when combining
> cells together? For instance, my formula is =c4&" "e4. I would li...View all linked cells?
I was wondering if anyone knew of a way to display a list of all link
in a given workbook?
Similar to looking at the source code to a website.
Thank you for you time
Message posted from http://www.ExcelForum.com
maybe not exactly what you're looking for but see
> I was wondering if anyone knew of a way to display a list of all
> in a given workbook?
> Similar to looking at the source code to a website.
> Thank you for you time!
&g...Go to Blank Cell Macro Problem
I am trying to get a macro to go to the first blank cell in a specific
i.e. column A has data from row A1 to A15. I'd want to run a macro that will
select cell A16.
I found this code below which does this on a 'Normal' sheet.
The problem i have is that the window is split and frozen at cell A1 (to
retain headings and the Button for the macro).
This seems to be preventing the code from running correctly.
Can anyone suggest an alteration to the code, or a different approach?
Set Rng = Range("a2")
If Not IsEmpty(Rng.Value) Then
If IsE...How do I calculate a weighted average and exclude the empthy cells
I am looking to complete my formula for calculated weighted averages.
Here is what I have:
A B C D
1 weight 20% 30% 50% Avg results
2 results 1 100% 100% 90% 95%
3 results 2 100% 90% 47%
The formula I have thus far is for D2: =average(a2*$a$1)+(b2*$b$1)+(c2*$c$1)
which works, however, when I apply the same formula to row 3, it creates an
incorrect average as it calculates the empty cell. Can someone please help
me resolve my delemna and provide me with possible solution? Thank you!
1. H...Changing a cell color to reflect positive or negative total
How do I add a formula to make a cell color (red for negative, green for
positive) reflect a positive or negative total when adding/subtracting 2
i.e. cell A43-A49, total sits in cell E49. If total is negative, then cell
E49 turns red; if positive, cell A49 turns green.
-A43 is a total of 40 previous cells added while A49 is the total of 4
previous cells added.
Use conditional formatting.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Alex Vega&quo...Hyperlink button to a specific cell in excel
I've set up a database made up of 60 + files and god knows how many
worksheets using hyperlinks; however, I would like use buttons instead of
hyperlinks in some cases because it looks more professional and indicative of
what one would expect a database to look like. Anyways, I need the links to
be able to jump to a specific cell in a specific worksheet in a specific
workbook just like I'm able to do using hyperlinks. Help Pl
If, for example, a hyperlink was in cell C6, the following macro
placed in the worksheet module would "run" the hyperlink.
You ca...XL2003: Pulldowns usu. to populate 1 cell, can we have entries for 3 cells?
I was wondering about something. This would revolutionize things
considerably; I have a spreadsheet that I created 5 years ago that I
use repeatedly. The difficulty is that if I could expand its
efficiency, then it would be much more useful and would cut down on my
When I enter items into the hidden worksheet that provides the
pulldown info, it is usu. data that populates 1 cell in the column of
the target sheet that is pulling the data. 1:1, in other words. Is
there a way to have several pieces of information that populate
several different cells in the target sheet?
...macro to copy and edit then delete a worksheet
I have created a macro that will open the workbook, print preview, copy a
worksheet. After I create the copy I want to edit the contents then print a
range. Upon exiting I want to delete the copy I created save and close the
workbook. I have been able to do everything except do the editing in the
worksheet before the macro prints, deletes and closes. Any suggestions
Are you copying the worksheet to a new workbook? If yes, then you can do all
your editing, print it and just close that workbook. Since that workbook hasn't
been saved, you don't need to delete it.
...How can I create a rule to copy OUTGOING mail to a specific folde.
I want to have e-mails that I send to various recipients automatically routed
to folders containing all my correspondence with them. So far, when I try to
create such a rule, it only ends up applying to INCOMING mail, not outgoing.
What am I missing?
You first. What version of Outlook?
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, ckanis asked:
| I want to have e-mails that I send to va...