Oct 10, 2006 Click the All Footnotes box arrow, and select Footnote Separator from the drop-down list. Click on the existing separator line and press Delete. Go to Format Borders And Shading. In the Find what box, enter either ^f for footnote or ^e for endnote. Alternatively, you can enter these symbols by clicking the More button to expand the dialog box, clicking Special, and choosing either Endnote Mark or Footnote Mark in the list. In Word 2016 for Mac, click the arrow at the bottom of the Find and Replace dialog box to show all. In this video I'll show you how to change the direction of the footnotes separator (footnotes line) from left to right, or from right to left, in any Microso. Jan 08, 2018 If you have both footnotes and endnotes defined in your document, Word displays the View Footnotes dialog box. (See Figure 1.) Figure 1. The View Footnotes dialog box. Click on the View Footnote Area radio button. Using the Footnotes drop-down list at the top of the Footnotes window, choose Footnote Separator. Feb 03, 2010 Footnote Separator Line Disappears. Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel This question was posted by someone in September; no reply is shown. When I insert a footnote in a Word for Mac document, a line separates the last line of text from the footnote. Then the separating line disappears.
In this post, we would like to share with you 4 methods to remove footnote or endnote separator in your Word document.
If you ever insert a footnote or endnote into document, you will find there is always a horizontal line over the texts. This separator marks out the footnote or endnote area clearly. Yet, some people may find it annoying and would like to get rid of it. This article will provide you with 4 methods to do so.
Method 1: Remove Footnote Separator Manually
- Firstly, click “View” tab then click “Draft” view.
- Next click “References” and then click “Show Notes” in “Footnotes” area.
- Now if your document contains both footnotes and endnotes, then there will be a box popping up. Choose to view either footnote or endnote area, then click “OK”. Now let’s choose “View footnote area” first.
- A note pane shall open at the bottom of the screen. Click the drop-down button to select “Footnote Separator”.
- Then click to have the separator in selection. Press either “Backspace” or “Delete” to remove the separator.
- And choose “Footnote Continuation Separator” then and delete it as well.
- When you get rid of the separator, there will be a blank line left which you can’t delete directly. Here we come up with a workaround. Endure the “Footnote Separator” is chosen.
- Then click “Home” tab and click the arrow button in “Paragraph” group to open the same name dialog box.
- Choose “Multiple” for “Line spacing”, set the value at “0.06” and click “OK”.
- Now the height of the blank line is reduced to the least. You can change the view back to “Print Layout”.
Check the result bellow:
Word For Mac Torrent
Method 2: Remove Endnote Separator Manually
- Repeat first 3 steps in method 1 but choose “View endnote area” this time in “Show Notes” box.
- In the note pane open at the bottom, choose “Endnote Separator” and select the separator. Then delete it.
- Next choose “Endnote Continuation Separator” and select the separator and delete it.
- Then choose “Endnote Separator” again by clicking the drop-down button.
- And repeat from step 8 to 10 in method 1.
Here is the result:
How To Modify Footnote Separator
Method 3: Remove Footnote Separator by Running Macro
- To begin with, press “Alt+ F11” to trigger the VBA editor in Word.
- Next click “Normal” then “Insert” tab.
- And choose “Module” next.
- Then double click to open it and paste the macro there:
- Click “Run”.
The macro shall remove all footnote separators automatically and minimize the blank line left as well.
![How How](/uploads/1/1/8/9/118926457/406786642.jpg)
Method 4: Remove Endnote Separator by Running Macro
Follow the exact steps in method 3 to install and run a macro. Only, replace codes with these ones:
Save Your Documents
No software is foolproof and this is very true of Word. Generally, it has been such a helpful tool for word processing. Yet, there are some down time while Word collapsing, leaving your document damaged. What’s worse, that document is the only copy you’ve got. This is so sad. But, if you choose a qualified utility to repair doc at once, you can end up with a totally different result.
How To Edit Footnote Separator
Author Introduction:
Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair xls and pdf repair software products. For more information visit www.datanumen.com
Related
Editing Footnotes
How can I change how the footnotes appear at the bottom of the page in a document that already exists with footnotes in it? Issues are: (1) Sometimes there is one space, (2) sometimes there is a tab before the footnote text -- both of which I think I've handled in the code below, and (3) in rare occassions, there is no space before the footnote text -- and I have no idea what to do in that case! I want to programatically edit all footnotes to appear with two spaces before the footnote text. Can someone please take a look and advise me (1) have I dealt with the first ...
Adding extra line message in Void Receipt ?
Hi,I 'm trying to add lines to a 'VOID' or 'REFUND' transaction receipts...Customer Name:______________________________Phone No. # __________________________________Signature _____________________________________This addtional line should only be printed if the transaction is VOIDED or REFUNDED. Is there anyone here have made this modification ? I am unable to trap where the VOID header is being called to print so that in the way only I will add this lines.thanks Try making your condition Transaction.Total and/or Transaction.TotalDue. For example...
Cluster Stack Column Line Chart in Windows vs Mac
I created a cluster-stacked column line chart on a Windows machine (Excel 2003) and sent the file to a user on a Macintosh. When the file was opened on the Macintosh, the chart becomes distorted (i.e. axis labels are incorrect, data in columns are missing). Any suggestions for how to fix this? Thanks. ...
Outlook 2003
Somehow I deleted the 'subject' line in my Outlook 2003 mail. I have to change each one individually and enter the 'subject' one by one.Is there any way to do this in one action as I have many many mailboxes and this is going to be a project.Any help would be appreciated.Thank you. You can start Outlook with the /cleanviews command line switch. This will delete all custom views and reset the built-in ones back to their defaults.How to:Start > Run > outlook.exe /cleanviews > OK button'Terri' <[email protected]> wrote in message news...
Two lines with a different x-series (please help)
I would greatly appriciate any help I could get on thisI am trying two plot two different lines on the same chartline 1 Line 2X axis Y axis X axis Y axi0 1.32 0 1.38.83 21.22 12.5 23.5I have no problem with the chart accepting the new Y values (as a different series) but as you probably know you can only have 1 catagory x label so my chart does not show the second line extending out to 12.5 it only extends to 8.83 on a different slope and stops. How do I get it to accept the addittional x value and still have to seperate lines? Thank yo Select the data for the second lineChoo...
How do I convert a line chart to a vertical line chart in Excel
data: yr_2007 yr_2008 yr_2009spring 20 75 35summer 60 25 80fall 55 40 100x : year y: value of count want convet to:x: value of county: year x If I understand you correctly, a XY Scatter chart would be the moreappropriate chart. Even though it and the Line chart look similar,the former offers a numeric x axis.On Wed, 19 Aug 2009 20:09:01 -0700, Gerty<[email protected]> wrote:> data:> yr_2007 yr_2008 yr_2009>spring 20 75 35>summer 60 25 80>fall 55 40 100>>x : year ...
how do i get my workbooks in separate windows?
i need to open my excel application in two seperate windows as they both keep appearing in one window. the tools, options, view, window taskbar thing did not work so i would like to know if anyone has any other ideas.thank you charlene charleneWhat is 'did not work'?If using Excel 2000 there was a bug with the Windows in Taskbar option notsticking when the workbook(s) were shared.Never fixed until Excel 2002 came out.OR do you want to see two actual workbooks side by side in the window?This could be achieved by Window>New Window and Window>Arrange>Vertical....
hovering cursor over footnote number in text
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I used to be able to hover the cursor over a foot/end note number in the document, and a mini window would show me the note text. All of a sudden, my cursor no longer works this way. I don't think I changed any settings, but can anyone tell me how I might fix this? <br><br>Thanks! Check another document: is that the same? You may have converted that footnote to hard text at some point, in which case there is no note text to show. Sorry: I can't think of anything else... On 11/03/10 5:32 AM, in article...
Report toolbar icon has disappeared
I just recently moved our MSCRM and SSRS Database from a SQL 2000 boxto a SQL 2005 box. Somewhere in the process the tiny report icon onthe toolbar for the account and other entities has disappeared.Wondering if this has happened to anyone or if anyone knows how to getthat icon/functionality back. Can you access the reports from workplace->reports?If you cannot see any reports in the reporting grid, the report icon on entities will be gone as well.If that is the case, that probably means upgrading of the report server was not working properly.Min Fan-- This posting is pro...
separate Undo for each individual sheet in a workbook?
Many times I find myself wanting to Undo commands done within a certain worksheet, without undoing other commands that might have been performed in other sheets in the meantime. However, if I have a couple of commands done in one sheet, then some other commands in another sheet, the Undo command will undo them all as if they were in the same list, without keeping track of the sheet where those commands were performed.Does anyone know a way to have separate Undo lists - one for each sheet of a workbook? Thanks!...
How to get the lines in an Excell document to print?
In an Excel document only the text in and above the columns prints. I want both the vertical and horizontal lines to also print. 'Robert-Harry' <[email protected]> wrote in message news:[email protected]...> In an Excel document only the text in and above the columns prints. I > want> both the vertical and horizontal lines to also print.Page Setup-Sheet-Print gridlines..... 'Robert-Harry' wrote:> In an Excel document only the text in and above the columns prints. I want > both th...
Footnotes
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you restart footnotes with Number 1 in each chapter of a document? I also can't remember how to do it, but I would do it by first looking in Word's Help. You can search for 'footnotes' and you'll should easily find the article 'Restart footnote or endnote numbers'. --rms www.rmschneider.com On 12/05/10 13:40, [email protected] wrote: > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you > restart footnotes with Number 1 in each chapter of a docu...
How can I copy a chart
when I try to copy my chart into a PPT slide, I get a circle with a line in it - and I can't copy. It's like I have read only access but I don't remember doing anything funky...help??!! From XL: Select your chart (make sure its the chart, not a series/legend or plot area) Copy. In PowerPoint: Go to Edit - Paste Special. Select a picture format (probably PNG format, or metafile). -- Best Regards, Luke M *Remember to click 'yes' if this post helped you!* 'Pasqua' wrote: > when I try to copy my chart into a PPT slide, I get a circle ...
How do I add footnotes in Publisher? #2
How do I add footnotes or endnotes to a passage in Publisher? Is it possible? I know in Word you go to Insert->Reference->Footnote, but there isn't a 'reference' tab in Publisher. Hi kgoff ([email protected]),in the newsgroupsyou posted:|| How do I add footnotes or endnotes to a passage in Publisher? Is it|| possible? I know in Word you go to Insert->Reference->Footnote, but|| there isn't a 'reference' tab in Publisher.Publisher doesn't have this feature. You have to create them manually...usually using superscript etc....
Does MS CRM have to be on separate server?
I have read that in cases where the server machine is running MS Small Business Server, MS CRM cannot co-exist with MS SQL Server or MS Exchange Server.Does anyone know why this is the case or if it can be overcome using vmware or something similar? Hi,it is actually the opposite, the only single box supported configurationwith CRM is with Small Business Server.-- Olivier SchmittMicrosoft Business Solutions SupportCe message est fourni en l'�tat, sans garantie d'aucune sorte, et ne vousconf�re aucun droit. Vous assumez tous les risques li�s � son utilisation.'Stu&...
Changing footnotes to endnotes
How do I change footnotes to endnotes in Word 97? -- Steve Hayes from Tshwane, South Africa Web: http://hayesfam.bravehost.com/stevesig.htm Blog: http://methodius.blogspot.com E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk Not sure about Word 97, but in 2000 and 2003 go to the Footnote reference create dialog, in 2003 this is under Insert, Reference, Footnote, on this dialog there is a Convert button, clcik this and you have choice of Converting All Footnotes to Endnotes, Converting All Endnotes to Footnotes, and Swap Footnotes and Endnote...
Combine varied data from separate workbooks into one chart
I want to combine varied data from separate workbooks into one chart.Data is collected at varied date intervals and level ranges (11/03-2/07) & (0-100). Data begins with 24k rows and is filtered to 1K. Individual charts display daily data labeled as varied mm/dd/yy on the ‘Category Axis’ and 0-40, 0-60 & 0-100 on the ‘Value Axis’. Adding additional ‘Series’ just gives one horizontal line.TIA Here are some guidelines: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html- Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom Solutionshttp://Pel...
CCRM Client will not go back on line
When trying to go back online one of our CRM clients tries to snychronize about 100 contactcs and fails with the following message: 'Failed move data for entity 'Contacts' during action salnsert. count Rows=100'When we re-tried we found that the number of Contacts to snych had dropped in half with a corresponding change in the error message 'countRows=50'. The count dropped in half each time we tried to go back online until it reached 5 (with the corresponding error message: 'Failed move data for entity 'Contacts' during action salnsert. count ...
line chart expansion
I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem.Any ideas on how I can fix this? The series that don't expand, is their data in a different workbook? Is the different workbook open or closed? I...
To Do List disappeared
Running OL 07 which is current. Recently, the ToDo list that displays in the To Do Bar has been replaced with the message: 'The operation failed. An object could not be found' What do I need to do to fix this? -- 'Pyramid 36' Ken Restart outlook using the /resettodobar switch. See http://www.slipstick.com/problems/todo_bar_error.asp -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:[email protected]...
In Publisher 2003, convert endnotes to footnotes
How do you convert endnotes to footnoests in Publisher 2003How do you automatically place footnoes in Publishr 2003 In WORD its easy, but can't determine how to do it in publisher.If impossible in Publisher 2003 Is there a Utility that accomplishes this?? jerome <[email protected]> was very recently heard toutter:> How do you convert endnotes to footnoests in Publisher 2003Footnotes and endnotes are both things which don't exist as separate functions in Publisher.> How do you automatically place footnoes in Publishr 2003You cannot.> If imp...
Un-numbered horizontal lines
Thank you for this service, it sure is a big help!!I copied some code that was on this site for horizontal lines in a report. The code works great except the lines are number 1-30. I need the horizontal lines but without the numbers. I tried changing some of the code but I don't understand enough to take the part out that numbers the lines. Below is the code, would someone please help me understand what to take out to change the code to make un-numbered lines? THANK YOU TONS!!!!!Private Sub Report_Page() Dim intNumLines As Integer Dim intLineNumb As Integer Dim i...
separate columns
Hi,I am having a little problem and I was wondering if any of you coulhelp me with it. I have two columns, A (Definitions) and B is empty.Column A has several words in a single cell, I was wondering if theris a way to put only the first word from cell A1, for example, in celB1. Thanks.Regards,Marco--Message posted from http://www.ExcelForum.com Hi Marcos!Try:=LEFT(A1,FIND(' ',A1)-1)-- RegardsNorman Harker MVP (Excel)Sydney, [email protected]'marksuza >' <<[email protected]> wrote in message news:ma...
Win2K3 NTbackup Creating Separate Files
Hi, I was wondering but how can you create a backup job using NTbackup so that instead of appending backups to a existing file it creates new files everytime it is run? My back up device is a 1.5 Tb hard drive. I want the backup job to create a new .bkf file everytime the job is run and to name it backup122409, backup122509, and so forth. The number would indicate the date that the job is run. I want to do it this way because it's easier to manage mutiple files rather than one gigantic file. -- Thank you for your help! JYC This article should sort it. How to u...
Footnotes
I have a title page for a document with footnotes for each author (4 of them) to indicate their affiliation. I want the footnotes for the text to begin with 1 and then continue all the way through the document (80 pages). However, I have several landscape pages in the document so have had to create several section breaks (thus the restart each section isn't what I want). Is there a way to do this? I don't want to restart each section; I just want the cover page to have separate footnote numbering. I know I can do it by hand, but was hoping there might be a way to do ...
How can I change how the footnotes appear at the bottom of the page in a document that already exists with footnotes in it? Issues are: (1) Sometimes there is one space, (2) sometimes there is a tab before the footnote text -- both of which I think I've handled in the code below, and (3) in rare occassions, there is no space before the footnote text -- and I have no idea what to do in that case! I want to programatically edit all footnotes to appear with two spaces before the footnote text. Can someone please take a look and advise me (1) have I dealt with the first ...
Adding extra line message in Void Receipt ?
Hi,I 'm trying to add lines to a 'VOID' or 'REFUND' transaction receipts...Customer Name:______________________________Phone No. # __________________________________Signature _____________________________________This addtional line should only be printed if the transaction is VOIDED or REFUNDED. Is there anyone here have made this modification ? I am unable to trap where the VOID header is being called to print so that in the way only I will add this lines.thanks Try making your condition Transaction.Total and/or Transaction.TotalDue. For example...
Cluster Stack Column Line Chart in Windows vs Mac
I created a cluster-stacked column line chart on a Windows machine (Excel 2003) and sent the file to a user on a Macintosh. When the file was opened on the Macintosh, the chart becomes distorted (i.e. axis labels are incorrect, data in columns are missing). Any suggestions for how to fix this? Thanks. ...
Outlook 2003
Somehow I deleted the 'subject' line in my Outlook 2003 mail. I have to change each one individually and enter the 'subject' one by one.Is there any way to do this in one action as I have many many mailboxes and this is going to be a project.Any help would be appreciated.Thank you. You can start Outlook with the /cleanviews command line switch. This will delete all custom views and reset the built-in ones back to their defaults.How to:Start > Run > outlook.exe /cleanviews > OK button'Terri' <[email protected]> wrote in message news...
Two lines with a different x-series (please help)
I would greatly appriciate any help I could get on thisI am trying two plot two different lines on the same chartline 1 Line 2X axis Y axis X axis Y axi0 1.32 0 1.38.83 21.22 12.5 23.5I have no problem with the chart accepting the new Y values (as a different series) but as you probably know you can only have 1 catagory x label so my chart does not show the second line extending out to 12.5 it only extends to 8.83 on a different slope and stops. How do I get it to accept the addittional x value and still have to seperate lines? Thank yo Select the data for the second lineChoo...
How do I convert a line chart to a vertical line chart in Excel
data: yr_2007 yr_2008 yr_2009spring 20 75 35summer 60 25 80fall 55 40 100x : year y: value of count want convet to:x: value of county: year x If I understand you correctly, a XY Scatter chart would be the moreappropriate chart. Even though it and the Line chart look similar,the former offers a numeric x axis.On Wed, 19 Aug 2009 20:09:01 -0700, Gerty<[email protected]> wrote:> data:> yr_2007 yr_2008 yr_2009>spring 20 75 35>summer 60 25 80>fall 55 40 100>>x : year ...
how do i get my workbooks in separate windows?
i need to open my excel application in two seperate windows as they both keep appearing in one window. the tools, options, view, window taskbar thing did not work so i would like to know if anyone has any other ideas.thank you charlene charleneWhat is 'did not work'?If using Excel 2000 there was a bug with the Windows in Taskbar option notsticking when the workbook(s) were shared.Never fixed until Excel 2002 came out.OR do you want to see two actual workbooks side by side in the window?This could be achieved by Window>New Window and Window>Arrange>Vertical....
hovering cursor over footnote number in text
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I used to be able to hover the cursor over a foot/end note number in the document, and a mini window would show me the note text. All of a sudden, my cursor no longer works this way. I don't think I changed any settings, but can anyone tell me how I might fix this? <br><br>Thanks! Check another document: is that the same? You may have converted that footnote to hard text at some point, in which case there is no note text to show. Sorry: I can't think of anything else... On 11/03/10 5:32 AM, in article...
Report toolbar icon has disappeared
I just recently moved our MSCRM and SSRS Database from a SQL 2000 boxto a SQL 2005 box. Somewhere in the process the tiny report icon onthe toolbar for the account and other entities has disappeared.Wondering if this has happened to anyone or if anyone knows how to getthat icon/functionality back. Can you access the reports from workplace->reports?If you cannot see any reports in the reporting grid, the report icon on entities will be gone as well.If that is the case, that probably means upgrading of the report server was not working properly.Min Fan-- This posting is pro...
separate Undo for each individual sheet in a workbook?
Many times I find myself wanting to Undo commands done within a certain worksheet, without undoing other commands that might have been performed in other sheets in the meantime. However, if I have a couple of commands done in one sheet, then some other commands in another sheet, the Undo command will undo them all as if they were in the same list, without keeping track of the sheet where those commands were performed.Does anyone know a way to have separate Undo lists - one for each sheet of a workbook? Thanks!...
How to get the lines in an Excell document to print?
In an Excel document only the text in and above the columns prints. I want both the vertical and horizontal lines to also print. 'Robert-Harry' <[email protected]> wrote in message news:[email protected]...> In an Excel document only the text in and above the columns prints. I > want> both the vertical and horizontal lines to also print.Page Setup-Sheet-Print gridlines..... 'Robert-Harry' wrote:> In an Excel document only the text in and above the columns prints. I want > both th...
Footnotes
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you restart footnotes with Number 1 in each chapter of a document? I also can't remember how to do it, but I would do it by first looking in Word's Help. You can search for 'footnotes' and you'll should easily find the article 'Restart footnote or endnote numbers'. --rms www.rmschneider.com On 12/05/10 13:40, [email protected] wrote: > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you > restart footnotes with Number 1 in each chapter of a docu...
How can I copy a chart
when I try to copy my chart into a PPT slide, I get a circle with a line in it - and I can't copy. It's like I have read only access but I don't remember doing anything funky...help??!! From XL: Select your chart (make sure its the chart, not a series/legend or plot area) Copy. In PowerPoint: Go to Edit - Paste Special. Select a picture format (probably PNG format, or metafile). -- Best Regards, Luke M *Remember to click 'yes' if this post helped you!* 'Pasqua' wrote: > when I try to copy my chart into a PPT slide, I get a circle ...
How do I add footnotes in Publisher? #2
How do I add footnotes or endnotes to a passage in Publisher? Is it possible? I know in Word you go to Insert->Reference->Footnote, but there isn't a 'reference' tab in Publisher. Hi kgoff ([email protected]),in the newsgroupsyou posted:|| How do I add footnotes or endnotes to a passage in Publisher? Is it|| possible? I know in Word you go to Insert->Reference->Footnote, but|| there isn't a 'reference' tab in Publisher.Publisher doesn't have this feature. You have to create them manually...usually using superscript etc....
Does MS CRM have to be on separate server?
I have read that in cases where the server machine is running MS Small Business Server, MS CRM cannot co-exist with MS SQL Server or MS Exchange Server.Does anyone know why this is the case or if it can be overcome using vmware or something similar? Hi,it is actually the opposite, the only single box supported configurationwith CRM is with Small Business Server.-- Olivier SchmittMicrosoft Business Solutions SupportCe message est fourni en l'�tat, sans garantie d'aucune sorte, et ne vousconf�re aucun droit. Vous assumez tous les risques li�s � son utilisation.'Stu&...
Changing footnotes to endnotes
How do I change footnotes to endnotes in Word 97? -- Steve Hayes from Tshwane, South Africa Web: http://hayesfam.bravehost.com/stevesig.htm Blog: http://methodius.blogspot.com E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk Not sure about Word 97, but in 2000 and 2003 go to the Footnote reference create dialog, in 2003 this is under Insert, Reference, Footnote, on this dialog there is a Convert button, clcik this and you have choice of Converting All Footnotes to Endnotes, Converting All Endnotes to Footnotes, and Swap Footnotes and Endnote...
Combine varied data from separate workbooks into one chart
I want to combine varied data from separate workbooks into one chart.Data is collected at varied date intervals and level ranges (11/03-2/07) & (0-100). Data begins with 24k rows and is filtered to 1K. Individual charts display daily data labeled as varied mm/dd/yy on the ‘Category Axis’ and 0-40, 0-60 & 0-100 on the ‘Value Axis’. Adding additional ‘Series’ just gives one horizontal line.TIA Here are some guidelines: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html- Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom Solutionshttp://Pel...
CCRM Client will not go back on line
When trying to go back online one of our CRM clients tries to snychronize about 100 contactcs and fails with the following message: 'Failed move data for entity 'Contacts' during action salnsert. count Rows=100'When we re-tried we found that the number of Contacts to snych had dropped in half with a corresponding change in the error message 'countRows=50'. The count dropped in half each time we tried to go back online until it reached 5 (with the corresponding error message: 'Failed move data for entity 'Contacts' during action salnsert. count ...
line chart expansion
I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem.Any ideas on how I can fix this? The series that don't expand, is their data in a different workbook? Is the different workbook open or closed? I...
To Do List disappeared
Running OL 07 which is current. Recently, the ToDo list that displays in the To Do Bar has been replaced with the message: 'The operation failed. An object could not be found' What do I need to do to fix this? -- 'Pyramid 36' Ken Restart outlook using the /resettodobar switch. See http://www.slipstick.com/problems/todo_bar_error.asp -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:[email protected]...
In Publisher 2003, convert endnotes to footnotes
How do you convert endnotes to footnoests in Publisher 2003How do you automatically place footnoes in Publishr 2003 In WORD its easy, but can't determine how to do it in publisher.If impossible in Publisher 2003 Is there a Utility that accomplishes this?? jerome <[email protected]> was very recently heard toutter:> How do you convert endnotes to footnoests in Publisher 2003Footnotes and endnotes are both things which don't exist as separate functions in Publisher.> How do you automatically place footnoes in Publishr 2003You cannot.> If imp...
Un-numbered horizontal lines
Thank you for this service, it sure is a big help!!I copied some code that was on this site for horizontal lines in a report. The code works great except the lines are number 1-30. I need the horizontal lines but without the numbers. I tried changing some of the code but I don't understand enough to take the part out that numbers the lines. Below is the code, would someone please help me understand what to take out to change the code to make un-numbered lines? THANK YOU TONS!!!!!Private Sub Report_Page() Dim intNumLines As Integer Dim intLineNumb As Integer Dim i...
separate columns
Hi,I am having a little problem and I was wondering if any of you coulhelp me with it. I have two columns, A (Definitions) and B is empty.Column A has several words in a single cell, I was wondering if theris a way to put only the first word from cell A1, for example, in celB1. Thanks.Regards,Marco--Message posted from http://www.ExcelForum.com Hi Marcos!Try:=LEFT(A1,FIND(' ',A1)-1)-- RegardsNorman Harker MVP (Excel)Sydney, [email protected]'marksuza >' <<[email protected]> wrote in message news:ma...
Win2K3 NTbackup Creating Separate Files
Hi, I was wondering but how can you create a backup job using NTbackup so that instead of appending backups to a existing file it creates new files everytime it is run? My back up device is a 1.5 Tb hard drive. I want the backup job to create a new .bkf file everytime the job is run and to name it backup122409, backup122509, and so forth. The number would indicate the date that the job is run. I want to do it this way because it's easier to manage mutiple files rather than one gigantic file. -- Thank you for your help! JYC This article should sort it. How to u...
Footnotes
I have a title page for a document with footnotes for each author (4 of them) to indicate their affiliation. I want the footnotes for the text to begin with 1 and then continue all the way through the document (80 pages). However, I have several landscape pages in the document so have had to create several section breaks (thus the restart each section isn't what I want). Is there a way to do this? I don't want to restart each section; I just want the cover page to have separate footnote numbering. I know I can do it by hand, but was hoping there might be a way to do ...