most recent 30 from http://officequestions.com 2010-03-10T03:21:32Z http://officequestions.com/feeds http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://officequestions.com/questions/94/how-do-pivot-tables-work-in-excel Gustav39 2009-10-15T22:54:58Z 2010-03-05T05:27:19Z

<p>I've come across the concept of Pivot Tables, but don't really understand them. Can anyone enlighten me?</p>

http://officequestions.com/questions/120/is-it-possible-to-save-a-pivot-table-formatting-template Pivot Ninja 2009-10-16T20:54:43Z 2010-03-04T18:25:26Z

<p>In my office we have a standard format for all pivot table reports. Consistent colors, fonts, bold sub-totals, etc.</p> <p>We also use the outline format exclusively.</p> <p>Each time i create a new Pivot Table report, I find myself reapplying all of these required styles. It would be great if I could save the styles as a template so that I could quickly apply it to any new Pivot Table.</p> <p>Is this possible?</p> <p>Thanks</p>

http://officequestions.com/questions/160/word-documents-opening-in-code doug 2009-11-04T03:47:50Z 2010-03-04T18:25:26Z

<p>what do i have to do to get me word documents to open in readable print. They open in code. I know the documents are good because i can open them from a different computer but cant on this one</p>

http://officequestions.com/questions/166/how-can-i-change-my-acount-settings-in-outlook-when-it-closes-down-when-it-fails setjmp 2009-11-16T16:48:15Z 2010-03-04T17:25:27Z

<p>I attempted (and failed) to properly configure Outlook today. Now when I start it up, it asks for a password. I enter the correct one (can verify using a separate machine), it fails to connect to the server and closes down Outlook. How do I "reset" outlook and start from scratch?</p> <p>Thanks!</p>

http://officequestions.com/questions/171/cell-entry-numbering Holliday 2010-01-12T18:21:01Z 2010-03-04T17:25:27Z

<p>How do I show a line number of cell entries in a column as I continue keying?</p>

http://officequestions.com/questions/55/advice-to-new-office-users-which-app-would-you-point-to-them-first Ferdeen 2009-10-14T13:38:53Z 2010-03-04T16:25:09Z

<p>My mum (and dad) have recently started using a PC (they are in their sixties) and I was trying to explain MS Office to them. They didn't get it.</p> <p>I was wondering which app do you think would help them start getting to grips with office ? Word ? Excel ? </p>

http://officequestions.com/questions/72/custom-toolbars-in-office-2007 Ian Turner 2009-10-15T15:42:14Z 2010-03-02T17:25:23Z

<p>My company recently upgraded from Office 2003 to Office 2007. When I was working in Office 2003 I created a really useful little floating toolbar with lots of useful little tools. I can't see a way of creating a similar toolbar in Office 2007. Does anyone have any idea how I could do this? </p>

http://officequestions.com/questions/145/how-do-i-unlink-power-point-from-excel Anthony 2009-10-21T11:27:53Z 2010-02-24T18:14:59Z

<p>Hi</p> <p>I frequently create graphs in excel 2007 for use in power point 2007 presentations. I first manipulate the chart in excel to get what I want and then cut and paste this into my ppt presentation. This works fine. However, when I change or delete this data in excel - this also changes the chart in my ppt. How to I break this linkage so that when I've created the chart I want it remains fixed?</p> <p>One work-around I've found is to do a screen grab and paste this in - but this isn't a very elegant solution.</p> <p>Thanks</p> <p>Anthony </p>

http://officequestions.com/questions/170/how-can-officequestions-help-you-get-a-job unknown (yahoo) 2010-01-10T13:44:28Z 2010-01-10T13:44:28Z

<p>Using Access's collect data wizard, I have set up an InfoPath form that will send the applicable people emails to update existing information for their respective entries.</p> <p>The InfoPath form that is generated automatically is what i need, i.e. it shows the current information in the database, allows users to update it as needed and submit the form via email and the access database is updated as information is updated.</p> <p>The problem i am having is trying to format the look of the email, mainly formatting the boxes and resizing and deleting some of the standard help wordings in the email.</p> <p>Do i have to recreate the form in InfoPath and then relink it to the database?</p> <p>Or is there an easier way to customize the email?</p>

http://officequestions.com/questions/169/recovering-a-not-saved-item Gary Anderson 2009-12-02T23:41:39Z 2009-12-02T23:41:39Z

<p>how do you recover an item without saving it</p>

http://officequestions.com/questions/8/useful-ms-word-shortcut-keys John Galt 2009-10-12T18:04:55Z 2009-11-24T15:49:15Z

<p>What are some short-cut key strokes that you find the most useful for MS Word. </p> <p>Obviously Ctrl-C, Ctrl-V.. but any other than that?</p>

http://officequestions.com/questions/165/setting-the-values-on-an-axis-of-a-colum-bar-chart Ian Turner 2009-11-11T11:18:51Z 2009-11-11T11:18:51Z

<p>I want to set the values in a column chart to be specific values but I can't see how to do this. Does anyone know how? </p>

http://officequestions.com/questions/97/how-can-i-get-the-traditional-menus-back-in-word-and-excel-2007 BasicallyMoney.com 2009-10-16T02:31:28Z 2009-11-10T20:22:53Z

<p>While the new Office 2007 ribbon is neat / cute / whatever, this particular old dog is familiar with the traditional Word and Excel menus. How can I get those menus back? Is there a setting for doing that, or is a third-party product required? I trust I'm not the only one who preferred the old menus. :-)</p>

http://officequestions.com/questions/29/creative-ways-to-play-jeopardy-using-powerpoint Hugh Akston 2009-10-13T11:56:34Z 2009-11-10T15:51:50Z

<p>Hi,</p> <p>I am an educator and want to use PowerPoint to play a quiz-like gameshow with my class - like Jeopardy. Getting started, this looks to be quite a task. I have slides prepared for each question, but I am not sure about how to jump back and forth between the main game board and each question slide. Keeping score would also be a plus, but I could do that offline if necessary.</p> <p>Has anyone done this in PowerPoint before, or know of some good examples i could follow?</p>

http://officequestions.com/questions/159/why-cant-i-move-the-word-2007-insertion-point-cursor-or-highlight-text-or-pictur k.c.s. 2009-11-01T16:15:21Z 2009-11-06T05:36:51Z

<p>Symptoms:</p> <p>1) The common fixes from the past do not resolve this problem on Windows 7 64-bit.</p> <p>2) When you open an existing Word document you are able to use the mouse as usual to move the insertion point cursor to different sections of the document, to select objects (like pictures) within the document, and to highlight existing text as expected. As soon as you type anything new anywhere in the document the mouse can no longer be used to move the insertion point to another location in the document nor can it select text or objects. The arrow and shift keys still allow you to move around the document and select objects.</p> <p>3) When you create a new document you are able to type normally and use the Enter key to add text to the Word document. As soon as you type anything in the document the mouse can no longer be used to move the insertion point to another location in the document nor can it select text or objects. The arrow and shift keys still allow you to move around the document and select objects.</p> <p>4) You CAN use the mouse to select Word menus and buttons on the ribbon bar but you cannot use the mouse on or inside the Word document itself once the condition occurs after typing begins. The mouse works fine and as expected in Excel and every other application.</p> <p>5) As soon as ANY open Word document is impacted by the "mouse stopped working" problem, all other open Word documents can't use the mouse either until Word is closed and you start the tests over again.</p> <p>Solutions that did not work for me:</p> <p>Similar symptoms have been reported by others using Word 2007 and 2003 on Windows 7, Vista, and XP but I have not found an acceptable solution to this problem with this system configuration. It seems related to some kind of UAC or permission problem or is 64-bit specific but I am not certain.</p> <p>I have already tried the following:</p> <ul> <li><p>Rerun Office Suite 2007 SP2 to confirm it was installed.</p></li> <li><p>Tried (twice) to rename the original, "HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Data" registry key as suggested in these posts. The new Data key gets created by Word and new values are added to the registry key but problem remains.</p></li> </ul> <p><a href="http://support.microsoft.com/default.aspx/kb/921541" rel="nofollow">http://support.microsoft.com/default.aspx/kb/921541</a></p> <p></p> <ul> <li>Other posts out there blame various Word Add-ins for the problem and have had success disabling or removing them.</li> </ul> <p>I only had 3 Add-ins showing as active, all from Microsoft. Two Visual Studio Tools for Office COM Add-ins and one Smart Tag "Person Name" add in. I ran Word as admin so I could disable both of the COM Add-ins. I renamed the FNAME.DLL file so the "Person Name" Add-in would not load because the Word GUI had all Smart Tag options dimmed and wouldn't let me uncheck that Add-in from the UI. I restarted Win, launched Word, and it showed no Active Application or Document Related Add-ins. No luck, mouse problem still present with all Add-ins removed.</p> <p>Bad Workaround:</p> <ul> <li><p>The only way I have found to USUALLY get the mouse to behave as expected and eliminate the problems described here is to force Word to "Run this program as administrator”. I opened the properties of the "Microsoft Office Word 2007" shortcut in the start menu, chose Compatibility tab, and chose that option under privilege level. Without running Word as administrator I have been unable to eliminate these mouse problems.</p></li> <li><p>Once you force Word to Run as admin, you now get the annoying warning prompt from Windows that asks you if it is okay to run as admin every time you start Word. This would be an almost tolerable workaround if all you ever did was create brand new Word documents. If you want to work on an existing Word document this solution isn't a good one, here is why:</p></li> </ul> <p>1) If you want to open an existing Word document from either the Windows 7 recent jump list menu or by double-clicking a Word doc file, the delay caused by the UAC prompt every time you start Word generates an error of, "There was a problem sending the command to the program.", and the document you wanted to open is not loaded into Word. You get the Word shell launched with no document. The only way to open an existing document while running as admin and getting the UAC prompt is to launch Word with no document or a new blank document and then manually open the existing document you really wanted via the Word menus.</p> <p>2) As a temporary option I tried to disable User Account Control (UAC) completely by telling it to NEVER notify me about anything. You would think that this would allow you to run Word as admin without the delay caused by the UAC prompt and then Word would open existing documents from the taskbar or by double-clicking as desired. I did the required restart after disabling UAC and confirmed that Word was still set to "run as admin". To my surprise, when UAC is totally disabled and no longer prompts you for permission each time you launch Word, the "run as admin" trick STOPS working. The existing documents now load from the taskbar or by double-clicking as desired because the UAC prompt delay is gone BUT the mouse problems come back!</p> <p>3) I have no idea why "run as admin" ONLY works if UAC prompts you for permission first and does NOT work if you tell it not to prompt you but that is what is happening on my system. I am still looking for a better solution.</p> <p>**Update to the "Bad Workaround" section: I experience the EXACT same behavior if I do NOT "run as admin" but instead tell the shortcut to Word to run in "Windows XP SP3 compatibility mode". Everything described above acts the same if I use either "run as admin" or "act like XP", this method ALSO required UAC to prompt me in order for it to work. If I tell UAC to not prompt me then the XP mode fails just like run as admin did. I am not sure what "run as admin" and "XP compat" have in common when running with UAC turned on but using either method results in the mouse working.</p> <p>Anyone have any ideas?</p> <p>System Info: </p> <p>Windows 7 Ultimate 64-bit, RTM Version 6.1.7600</p> <p>ThinkPad T61p (Lenovo) Laptop, 4GB RAM</p> <p>Word 2007 (12.0.6504.5000) SP2 MSO (12.0.6425.1000) Part of Office Ultimate 2007.</p> <p>Patched with all recommended updates for Windows/Office through Windows/Microsoft Update as of this post date.</p> <p>Latest nVidia Video Driver for Windows 7 64-bit installed (v8.16.11.8694), that version is in Windows Update and on Lenovo site.</p>

http://officequestions.com/questions/161/entry-form-in-excel Hugo Reyes 2009-11-04T15:32:42Z 2009-11-04T20:23:17Z

<p>My office has a contact list in Excel and we are always adding new contacts to the list. It's a shared doc that everyone is updating frequently. (Really this should probably be set up as a database in Access, but we're not there yet.) Is there a way to create a form where users can enter all the info and it will put all the info into a new row at the bottom of the list? Maybe with a macro?</p>

http://officequestions.com/questions/48/combining-office-programs-to-collect-and-analyze-survey-data-from-many-respondant Hugh Akston 2009-10-13T18:53:53Z 2009-10-29T22:29:14Z

<p>In my office we need to collect responses to a 20 question survey from over 200 respondants. An online survey tool is not an option. Obviously our challenges are:</p> <ul> <li>distributing the survey</li> <li>collecting valid data (e.g. dates in a consistent format, required fields, etc)</li> <li>an organized means of collecting the responses</li> <li>analyzing the responses through calculations like median, averages, sums, etc.</li> </ul> <p>Our attempt last year to do this failed miserably when we tried sending Word documents with form fields and instructions out to the respondants, asking that they email them back.</p> <p>My question then is, what would you recommend we use for this task?</p>

http://officequestions.com/questions/158/spell-checker-keeps-on-swithcing-off-in-microsoft-word-2007 Ian Turner 2009-10-29T12:08:57Z 2009-10-29T12:08:57Z

<p>For some reason the automatic spell checking seems to switch itself off when I'm using Microsoft Word. This is proving to be a real problem, but I can't track down what is happening. Does anyone have any ideas what I can do to prevent this? </p>

http://officequestions.com/questions/4/change-the-color-of-wavy-lines-for-word-spelling-and-grammar-checking John Galt 2009-10-12T17:53:47Z 2009-10-28T12:27:16Z

<p>Is there a way to change the color of the red and green squiggly lines that appear under words for spelling and grammatical errors?</p>

http://officequestions.com/questions/3/create-copy-of-spreadsheet-data-only-without-formulas John Galt 2009-10-12T17:48:06Z 2009-10-28T11:27:11Z

<p>I need to send copies of calculated data to other departments on a regular basis, but I do not want them to be able to see (or change) the formulas I use to arrive at the calculated figures. What is the best way to quickly copy all of the calculated data into a new sheet but not as formulas?</p>

http://officequestions.com/questions/154/printing-envelopes-with-addresses-of-my-outlook-contacts Sakin 2009-10-23T20:58:13Z 2009-10-26T13:10:52Z

<p>I have a large number of contacts on outlook, and I want to print envelopes with the addresses of all my contacts.</p> <p>How can I print different information on each envelope based on a condition like 'city'?</p>

http://officequestions.com/questions/47/reminder-in-outlook-that-subject-line-is-empty-like-in-gmail Hugh Akston 2009-10-13T18:35:42Z 2009-10-22T19:01:45Z

<p>Gmail has a great feature to let you know that the subject line is empty when you attempt to fire off an email without providing a subject.</p> <p>Is there a setting in Outlook that can serve the same purpose? Or does this require a macro?</p>

http://officequestions.com/questions/114/total-word-count-in-powerpoint Miles 2009-10-16T19:28:08Z 2009-10-22T13:12:17Z

<p>Is there a feature in PowerPoint that will tell me the total word count in all slides and/or slide notes?</p> <p>Thanks</p>

http://officequestions.com/questions/122/vba-code-to-compact-and-repair-access-database Hugh Akston 2009-10-16T21:04:20Z 2009-10-22T13:09:03Z

<p>This should be a fairly simple request:</p> <p>I am looking for the VBA code to execute a compact and repair on the current database.</p> <p>Thanks</p>

http://officequestions.com/questions/139/conducting-a-survey-with-office interneter 2009-10-18T23:38:18Z 2009-10-22T12:59:00Z

<p>Is it possible to create a survey and disseminate through out the office by using MSOffice, Office Live or in conjunction with Exchange?</p> <p>I've read that an alternative use of Google Docs is to use its excel-like app to <a href="http://www.ehow.com/how%5F4615530%5Fsurvey-using-google-documents-free.html" rel="nofollow">create online survey</a>. I was wondering if Office has something that is comparable.</p>

http://officequestions.com/questions/144/copying-an-pasting-from-graphs-excel-to-word-makes-the-text-size-change Ian Turner 2009-10-20T14:02:50Z 2009-10-21T12:58:48Z

<p>I recently upgraded from Office 2003 to Office 2007. It's a fairly basic workflow, but I used to copy graphs out of Excel and paste them into Word. The problem I am having is that in the latest version of Word the text size of legends / titles etc. changes when I do this so a nicely formatted graph is suddenly very badly formatted. Short of just taking a screen image, or similar, of the graph is there a simple solution to this problem?</p>

http://officequestions.com/questions/142/how-do-i-append-text-in-excel alberta 2009-10-20T12:10:55Z 2009-10-20T12:31:29Z

<p>For example I have a spreadsheet with one column 'Name', and one 'Address'.</p> <p>And I want to create a third column that will automatically display the text corresponding as "$Name lives in $Address"</p> <p>where $Name and $Address are the variables.</p> <p>How can I do that?</p>

http://officequestions.com/questions/141/how-can-i-get-web-pages-from-my-ms-access-database alberta 2009-10-20T09:59:44Z 2009-10-20T09:59:44Z

<p>Is there any way to:</p> <ul> <li>give as <strong>input</strong> -> my MS Access DB and especially my database forms</li> <li>receive as <strong>output</strong> -> <strong>web pages that do the same job as my database forms</strong>, but in web format ?</li> </ul>

http://officequestions.com/questions/140/multiple-lines-of-text-in-a-smart-art-organisation-chart Ian Turner 2009-10-19T13:11:08Z 2009-10-19T14:58:14Z

<p>I'm doing an organisation chart using Microsft Excel 2007 and the Smart aRt Organisation Chart. I'd like each box to have two lines of text, one for the name and the other for the individuals position. Is there any way of simply acheiving this using Smart Art or do I have to do this manually? I know that I can just click on the text in the Smart Art box and press enter and it creates a new line, but is there any way to set this behaviour up by default? </p>

http://officequestions.com/questions/134/onenote-or-word-for-quick-note-taking Taggart 2009-10-18T13:04:29Z 2009-10-18T20:20:10Z

<p>For quick note-taking: such as meeting minutes, requirements gathering sessions, or interviews - what are the advantages of using OneNote as opposed to MS Word?</p> <p>Also, if I take notes using OneNote will I be able to share my notes with other people that may not have OneNote installed?</p> <p>Thanks</p>