Mysterious Excel startup message
Q: Whenever I try to use Excel 2007 (Windows 7 64-bit system), I get error messages informing me that 'Excel cannot access Webplus. The document may be read-only or encrypted' and that 'Webplus cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only'. After I have clicked OK, Excel continues largely as before, but I can't get to the bottom of this irritation. Although I have Serif's Webplus on my system, I can't see how it could cause this problem. Can you help? Paul Martin A: In order to eliminate this, you'll need to see which files Excel is trying to open at startup. You can find the list by looking in the Excel Trust Center, via the File, Options dialog box. In the Trust Center dialog box, click on Trust Center Settings, then look in the Trusted Locations area. In here, you'll find a list of folders that Excel trusts, including at least a couple with 'XLStart' as part of the folder path. As an example, we can see C:\Users\Kay\AppData\Roaming\ Microsoft\Excel\XLStart\. Go to the Computer option in Windows, and browse through the folders until you get to the XLStart folder. We suspect that in your personal XLStart folder, you'll find a shortcut to Webplus. If so, it should only be a shortcut. Delete it, and the problem should disappear. Page numbers aren't working in Word Q: When I create documents in Word 2010, I have problems with page numbers. If I click on the 'More Page Numbers' option, the 'Save selection as Page number' choice is greyed out. When I did this in Word 2007, I saw pictures of the way page numbers would display in my document. Does this no longer work in Word 2010? Steve Barker A: This should work in Word 2010, and you can always insert a page number field directly using Alt-Shift-P. However, the problem is probably with a special file that Word uses, called the building blocks file. The problem can appear with Word 2007 or Word 2010. In each case, you need to find the file that's causing the problem and rename it, and then Word will recreate it. First, check whether the Building Blocks template is disabled in the Word Options dialog box and, if it is, make sure it is enabled. From the File menu, choose Options. Click on Add-Ins, and check the list of disabled items. If you see a reference to Building Blocks.dotx, Centerenable it, then exit and restart Word, and see if this helps. If this doesn't help, you'll need to work directly on the Building Blocks template. Shut down Word and look for one of the following files. If you're using Windows XP, look in C:\ Documents and Settings\<your username>\ Application Data\Microsoft\Document Building Blocks\1033\Building Blocks.dotx. If you're using Windows Vista or Windows 7, look in C:\Users\<your username>\AppData\ Roaming\Microsoft\Document Building Blocks\1033\Building Blocks.dotx. Rename the Building Blocks.dotx file as Blocks.old. You should see a second file in this location called Built-In Building Blocks.dotx. Right-click on this and, in the pop-up menu that appears, choose Properties, General. While in this tab, make sure the 'Hidden' option is not selected. Restart Word, and you should now find that you are able to insert page numbers. Why is Access adding pages to my report? Q: Why does Access 2010 add extra pages to reports that used to be single page in Access 2007? I've not changed anything other than the version of the software: I have the same printer, the same report design and the same data. All my single page reports are throwing an extra blank page and it's wasting loads of paper. The same problem also happens on longer reports, but it's not as annoying to get one blank page for every 30 pages of report as it is for every other page to be blank. Mohammed Kahn A: First, check which font you're using; if the font you originally used isn't present on your current system, and Windows has substituted a similar (but subtly different) font, it could be taking up a fraction more space and that could be enough to make your text boxes marginally bigger, throwing everything down the page. Next, you need to do some sensible and simple checks. A section of your report is taking space where you don't expect it to. One problem is that if you put together sections such as Page Header, Detail Header, Sub Report Header, Sub Report Page Header, and Sub Report Detail Header, all of which have properties such as Can Grow, Can Shrink, Keep Together, and Force New Page, and Auto Height, you wind up with hundreds of formatting choices. One choice that seems to cause problems in Access 2010 is Force New Page. If the Force New Page property is set to <After Section>, you'll get a blank page printed at the end of the report. So what you need to do is force a new page before the group header instead of after the group footer. In the report's Group Header, set the Force New Page property to <Before Section>, and in the report's Group Footer set the Force New Page property to <None>. If that doesn't help, then one way for you to see which section is actually causing the problem is to take each one in turn and set the background colour to something visible. That way, you should be able to identify which section is taking up space when it isn't supposed to be. You'll still have to investigate why that section is causing problems, but at least you'll know which elements to scrutinise. Missing Outlook messages Q: Conversation Clean Up feature in Outlook 2010 has saved space in my inbox by getting rid of old messages that are in newer messages. But are the old messages still available? John Charlton A: Conversations in Outlook can let you see all related messages as a stream. To see messages organised in this way, choose 'Show as conversations' from the View menu. All messages that share the same subject line are grouped in the order received. When a new message that's part of this conversation is received, the whole conversation moves to the top of your inbox. Conversations that include unread messages have their subject lines displayed in bold, and if a conversation splits because of two or more responses, the conversation can split into multiple related but separate conversations. The 'Clean Up Conversation' option involves clicking the drop-down arrow next to Clean Up in the Delete group on the Home tab of the Office ribbon. Redundant messages are moved to the Deleted Items folder. Outlook defines redundant messages as part of the current conversation, read, not the newest and not flagged or categorised. The newest message should contain the text of older messages. If old emails are in the Deleted folder, they are available until you empty the folder. If you want to retain them for longer, set up a special folder using File, Options, Mail. In the Conversation Clean Up section, you can specify whereabouts the messages that you clean are moved, plus set whether to move messages that are flagged, digitally signed and categorised. Strange lines on PowerPoint images Q: When I import JPEG images into PowerPoint 2007, I often (but not always) get an unwanted frame line at the left-hand side and top. The only way I can get rid of these is to use the crop tool to delete them. What's even more irritating is that the lines sometimes only appear in copies I've emailed to someone. If I insert the same picture into PowerPoint 2003, the problem doesn't happen. How can I prevent the lines appearing? Julian Kent A: This problem can happen with compressed large JPEGs. Fortunately, it seems to have been solved in PowerPoint 2010. The underlying problem is a combination of PowerPoint not recognising embedded colour profiles and the 'auto-compression on save' feature that PowerPoint uses. If you're working on the JPEG in Photoshop, make sure you untick the box labelled 'Embed ICC profile'. Having this ticked can be one cause of the problem, as PowerPoint 2007 can't seem to read an embedded colour profile. It's also worth cutting the picture, then using 'Paste Special as Jpeg'. This seems to make PowerPoint recognise the format better. Another technique we've seen is to format the picture as 3-D Format and to set the Contour colour to match the background colour of the background the picture is placed on. Finally, make sure you remember to choose the 'Do not compress images in File' option when you create a new presentation. You'll find this option in the PowerPoint File, Options, Advanced menu. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
