I want to save a new template under excel office. The error message is "Progfile (X86)\microsoft office\office14\xlstart\book.xltx You dont have permission to save to this location. Contact Administrator to obtain permission."
I am the administrator. I am the only user account setup. What is causing this problem?
I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.
I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.
You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)
Enter the .reg key into your registry by double clicking on it and then navigate to the said folder or object you are trying to save to and right click on it and "take ownership" of the folder or object. Then try and save it again. Hope this helps,
On one computer, when I open Excel 2010 templates it doesn't open it in Excel. It previews in my explorer window as shown in this screenshot but doesnt open but on another computer it will open as normal.
Turn off your preview pane, which is that square box on the upper right. That should disable the preview and open the document in Excel.
I have a user using Excel 2010 when he opens a Excel file in our sharepoint site and does a save as it does not go to the location the file is saved the path in the save as box is his local machine. All of our users that have office 2007 do not have this issue. I have configured his trust settings to allow saving to the sharepoint site to no avail. I am about to tell him he needs to revert to 2007 but would rather solve the issue first. Any help appreciated I am beating my head against the wall
Hi! THaygood, welcome to 7F
Does this make any sense?
My IT Experiences: Issue with Save to SharePoint in Excel 2010
I have a problem when using Excel 2010 in that when I 'Right Click' a cell to change something like Fill or Border etc, the Format box is hidden behind the work book? I have found that by switching to Outlook and then Minimizing it, the Format box is shown. However, when I click anything to try and change, the box disappears again behind the work book? The same thing happens if I try 'Save As'? Very frustrating!
When I try to save a file to a folder I have in MS Excel 2010 I don't see all the that are really in that folder. Only the last 10 or so are there. My boss is trying to save an excell document into his Project Folder but when he hits save as only certain documents show up and none of them are the Folders that are definately created and can be accessed when you go to Windows Explorer. Is there a way to change this?
Read other 10 answers
Hi folks, got a question re: Excel 2010, running on win7 Pro 32-bit (it's not the machine in my stats).
I looked up tutorials to change the default save folder location for MS Office, and pretty much all of them reference MS Word 2010. Like for example the one in this forum, MS Office Word : Set Default Save Location -- which works fine when I try it, no problem with Word 2010. However, Excel 2010 is being a **** and refuses to following spec.
When I click on File -> Options, then navigate to the "Save" tab, it displays a screen similar to the equivalent one in Word... except that the "Browse" button to change the folders is missing.
No big deal, plus the default file location is already pointing to my user folder: that's fine. However, when I go to save or save-as, this is what pops up:
Yea-- no. Why is Excel showing libraries? I don't want to use libraries. I don't want to see libraries. I've used the registry hack from this forum to remove libraries from showing up in the left pane of Explorer.
How do I get Excel to use my documents folder as the default?
After changing the location in the Excel Options --> Save tab... did you reboot?Read other 9 answers
Hello all. Not a regular user of Excel; but do need help in creating something that would be useful to me and a few others at work. I suppose the best way of explaining what I'm after is by giving an example.
I have a directory C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson
In Cape Nelson are a number of folders named alpha beta charlie delta echo and foxtrot and so on.
I would like to have an excel template in "Cape Nelson" with a macro that when activated names the file as whatever folder name might be in say cell A1 and whatever ever date might be in cell B1. Eg charlie_15-mar-2013.xls
This then is saved in the relevant folder. So in the end I would end up with
C:\Users\Tekko\Desktop\Maintenance Project\Cape Nelson\charlie\charlie_15-mar-2013.xls
Also the macro script would ensure that the macro was disabled in the saved file.
Hoping this is achievable and look forward to replies.
Read other 16 answers
I was recently upgraded to Windows 7 and Office 2010. Under my old version of Windows XP & Office XP/07, when I received an emailed spreadsheet & made adjustments to it, I was able to save it directly over the old emailed file. Now when I make any changes I am asked to save a copy of the file & to save it elsewhere on my computer & cannot save it directly over the original emailed spreadsheet.
Any ideas on how to get this old feature back? I'm sure it's just a matter of ticking some option off.
Are you opening the spreadsheet directly from an attachment in your email program? If so, what email program are you using?Read other 7 answers
Excel 2010 SUM Formula updates, save file and reopen - values revert to old yet SUM totals are new
We have a very strange problem, our user opened his .xls document (97-2003 format) yesterday and updated several values, copied formula and updated (eg monthly/weekly totals). The worksheet includes many small SUM's spanning a couple of cells with sub-totals. He then saved his work and shut down as usual.
When opening the .xls document this morning, to continue his work, he noticed some of the values had changed (we assume to the previous ones) yet the totals where still the updated 'saved' values. Changing any values causes Excel to recalculate the totals (which then become correct, yet old totals)
Yesterday I updated the computer from a Windows XP (SP3), Office XP (SP3) to a Windows 7 (32bit, SP1), Office 2010 (SP1).
We've advised him to change document types to the new .xlsx format and to doublecheck everything.
Any ideas to the actual cause? Thanks
Read other 6 answers
I never had this issue until I used the free upgrade from Windows 7 to Windows 10. I am the only user of my PC. I work with Microsoft Office 2007. When I open Microsoft Word, Excel or any other program in the suite I have no problem... not until I try to
save the file I'm working on. For example I open up Microsoft Word and work on a file. I go to save it and I get:
You don't have permission to save in this location. Contact the administrator to obtain permission.
Would you like to save in the Documents folder instead?
It was the documents folder that I was trying to save it in, in the first place.
I can open up any of the Microsoft Office programs by right clicking, and opening the drop down menu, and scrolling down to "Run as administrator".
I want to be able to open the program without right clicking (to Run as Administrator) to save whatever I'm working on. I never had to specify before the upgrade. I forget to right click on that, for the drop down menu, than I'm stuck trying to
figure out another way to do it without losing all my work.
How can I make this right without downgrading back to Windows 7? The only thing I haven't liked about the free upgrade is the administrator rights issues.
Hello Techies: I'm looking for an easier way to have a table checklist (it was copied and pasted to email from Excel) on outlook that's emailed to me daily to be a saved template on Outlook as opposed to the person sending it to me to go back into the previous email and write over previous data?
This is a checklist a person does everyday and updates a grid like table which I had copied into an outlook email. The subject is always the same so I have a folder rule whereby these daily emails are stored. The person goes into the previous day's email and copies the grid/template to a new email with the same subject tittle and enters the new data. I wonder if I can save a template of that grid so whenever the person clicks new email the template/grid automaticallly appears with the same subject tittle, thus avoiding the extra work of copying from an old email?
I created the following outlook template and would like to auto update <yesterday’s date> everytime I open my template. Any idea?
Subject: daily report for <current date>
The first attachment is for <yesterday's date>
The second attachment is also for <yesterday's date>
The third attachment is for <today's date>
This is the same issue as previously posted on this site, but none of the solutions have applied/worked, including the solutions posted here: http://office.microsoft.com/en-us/w...s-to-the-normal-dot-template-HA001151452.aspx
This prompt appears when I am trying to work quickly. In addition, when opening/closing Word docs and Outlook messages, it takes about 15 seconds or more.
I have Office 2003 with Windows Vista, and an HP Pavilion PC from 2007. Here is my scan:
Tech Support Guy System Info Utility version 220.127.116.11
OS Version: Microsoft® Windows Vista™ Home Premium, 32 bit
Processor: AMD Athlon(tm) 64 X2 Dual Core Processor 4400+, x64 Family 15 Model 107 Stepping 1
Processor Count: 2
RAM: 1917 Mb
Graphics Card: NVIDIA GeForce 6150SE nForce 430, 128 Mb
Hard Drives: C: Total - 296250 MB, Free - 230874 MB; D: Total - 8992 MB, Free - 1105 MB;
Motherboard: ASUSTek Computer INC., NARRA2
Antivirus: AVG Anti-Virus Free, Updated: Yes, On-Demand Scanner: Enabled
We currently switched from WordPerfect to Word 2010. In WordPerfect we had a macro for the letterhead where you typed in your information (or picked from a drop down list in some places) and then it would bring up your document for you to continue typing in. I need to set up the same thing in Word and thought of using forms etc. but I want to keep it as close to the WordPerfect way as possible.
Does anyone have any ideas on how I can acheive this?
Tech Support Guy System Info Utility version 18.104.22.168
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3-2120 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 4011 Mb
Graphics Card: DameWare Development Mirror Driver 64-bit, 5 Mb
Hard Drives: C: Total - 57138 MB, Free - 18546 MB;
Motherboard: Intel Corporation, DQ67SW
Antivirus: ESET Endpoint Antivirus 5.0, Updated and Enabled
I am relatively new to VBA so please bare with me.
The company I work for has multiple business divisions and each business has multiple branch locations.
The letter template needs to allow the user to select their business division in a combobox in a userform which will populate that field in a table in the footer.
I then need to populate the address and contact details, also contained in a table in the footer. I would like this information to be pulled from an excel spreadsheet which will allow for updates by administrators who may have very basic level knowledge of Word. The other option, I believe, is to use docvariables, but I am unsure of how they work. I can only assume that the information is manually entered into the userform and that the document remembers the information?
Any assistance is greatly appreciated. Thank you in advance.
Can you post a sample letter showing how the completed letter should appear?
According to the site below and a few others, the template folder is at
BET: Microsoft Word Templates - Normal.dot
C:\Documents and Settings\"user name"\Application Data\Microsoft\Templates\
I'm using Windows 7 64 bit and there is no Document and Settings Folder in Windows 7.
I can't find a Templates Folder in App Data either.
Please help, thanks.
"C:\Users\username\AppData\Roaming\Microsoft\Templates\Normal.dotm"Read other 2 answers
I just picked up an Acer Iconia Tab W500 series tablet pc
It has Microsoft Office Starter 2010 and I'd like to create a Word template without upsetting the default template or any others
Can you help me figure out how to do that?
I found a link to work on what I'd like to work with
Learn about templates in Office 2010
how do i modify sidebar word 2010 save as save in ?
i am running window 7
Hello mri1397, welcome to Seven Forums.
Sorry, but I am not sure what you mean.
Could you explain further - perhaps with a picture to illustrate.
I use mail merge only once a year, for holiday envelopes. So I'm unfamiliar with most of the options. My recipients are stored in Excel. I have saved a (single envelope) .docx with my return address and «FirstName» «LastName» «Address», etc. for recipient. But I don't know how to use it. Every year I have to start from scratch. Thankfully, I've made a checklist so that I don't have to learn everything anew each December.
It just makes sense to use the saved layout instead of redoing the whole process each time.
Where & how in the "Start Mail Merge/Envelopes/Select Recipients . . ." sequence do I tell it to use the saved layout (template)? Is a .docx the correct file type?
Ok, so I created a custom template and saved it as such (.dotx). And when I want to use it, I go File>New>My Templates>APA Format.dotx. All of that is fine, and the template works fine.
My question: can I have my custom template show up NEXT to the My Templates folder, Blank Document template, etc. Right now that top row of Available Templates has: Blank document, Blog post, Recent templates, Sample templates, My templates, and New from existing. I want to simply add my custom template to this row of options. That would allow me to select New> APA Format.dotx.
If you need a better explanation, please ask.
I appreciate any and all help!
Nobody knows how to do this?Read other 3 answers
Okay, so when I use a template for an email, it messes the whole thing up. Colors disappear, font changes, even bolding and underlining vanish, and I believe links no longer work. That is once it is sent, the "draft" everything looks perfect.
However I can take all the text from a template and put it in a new email and it will send as it should. I can even Forward the copy in my Sent Folder in Outlook and it will forward it as a Good email with no mess ups.
I could really use help with this as it is a nuisance when doing 10 or 20 emails based off of templates... I have tried to recreate the same templates but still have no luck with them. They were originally made with Outlook 2k3 if it matters.
Outlook1.jpg is how it looks before sending and how it should turn out..
Outlook2.jpg is how it gets sent back to me and anyone else viewing the email..
Maybe something in this link will clarify the matter for you:
How to Create and Use Templates in Outlook 2010 - How-To Geek
Or perhaps this one:
Send an email message based on a template - Outlook - Office.com
I am trying to create a template from a spreadsheet. I found instructions
which say to go to "file" then "save as" then "template." I cannot find
"template" anywhere in the "save as" option.
Which version of Excel?
2007 would be .XLTX older .XLT in the save as dialog box.
I am looking for an Excel template that i could us as an old inventory cardex. I want to use this to track the movement of about 200 rental items. Any suggestions?
can you provide details of what information you want to keep and track - there are lots of templates available on the net
and i usually do not do this - but I think in this case a google search would probably be the best option
if you can provide enough detail someone here may create a template
I'm stuck and need help! I am currently trying to create an RFI log and want to use a template for the RFI request. I have two worksheet in Excel - one for the template, the other as a log. I am trying to figure out how I can lookup the next available number in the log and reflect that on the template.
Read other 6 answers
I remembered how to creat an excel template, but cant remember how to force it to save as xls, rather then saving it as a template.
The problem I have is that the template is saved in a folder and other users need to be able to access it, now when a template is not in the default location, when you save it will save as a template rather then a spreadsheet.
Does any one of you guys know of a way around this?
I have to use excel 2003
Thanks for reading!
I edited the original post with some additional info
I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):
(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.
I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.
Nothing has worked. I’m barely able to get anything done! Please help, I’m dying here!
Read other 16 answers
I am trying to make Avery 5168 Labels but get this message:
"The margins, label size, and number across or down values produce a page that is larger than the label page size."
I'm not entering my own custom label sizes here - I'm selecting an Avery label from Word's own list. After selecting the Avery product I click on Details. There I can go down to page size and select Letter or Letter Landscape. Both are 8.5 x 11", but for some reason Landscape gets me the error message.
I have already set my document to Landcape in page layout thinking that might be the problem but that didn't fix the issue.
Any ideas? Thanks, H.T.
This Avery website may be useful for you as there is a program download there for creating Avery labels.
Avery Wizard | Microsoft Office 2013 | Mail Merge | Labelling | Avery Australia & New Zealand
This is my first post in this forum. I found this forum on the web looking for a template. Hope everyone will forgive my poor typing skills.
I am looking for an Excel spreadsheet or phone call log template whereby I could download my long distance telephone bill from a website, and paste it into a spreadsheet. I then have a sheet of frequently called numbers, which automatically pastes the person's name who called that number into the spreadsheet and tallies everything for that person. (Windows XP, Office 2003) I already checked MS Online.
>> forgive my poor typing skills
Didn't notice any.
>> I already checked MS Online
I don't know of any ; let's make one!
>> download my ... telephone bill ... and paste it into a spreadsheet
The numbers & amounts go in columns A & B respectively of the "Calls" sheet.
>> sheet of frequently called numbers
See table on "FCNs" sheet.
>> which automatically pastes the person's name ... into the sheet
The formula in column C of "Calls" looks up the UserName (from the FCNs table) for the number. You'd just need to copy it down as far as the list goes.
>> tallies everything for that person
There's a pivot table on the "Summary" sheet for this. To update it, you just rightclick it & choose "Refresh Data" from the pop-up menu.
Download the file, change the extension to xls, then check it out. Post back with how it needs tweaking to fit your needs.
Does Excel have a file associated with it similar to Word and normal.dot? When I open Excel I have 2 projects listed in the project window of the VB editor. AUTOSAVE.XLA and FUNCRES.XLA. Both are password protected. Are these 2 projects a normal part of Excel? If not how can I get rid of them?
those would be add-ins. Go to tools, Add-ins and uncheck them from there.
The computer involved is using Windows 7 Pro 64bit and Office Professional Plus 2010.
I am having a problem I cannot find a solution to. I have one user at a clients location that has recently stopped being able to save excel files in their my documents. The my docs is being redirected to a server. The files open correctly and can be edited, but when save is clicked an error box says the document not saved. Using cntrl-shift-i I found the error code to be 100490. I can open any other file and save them just fine. And any new excel documents can be opened and saved correctly. The file can be saved into the same folder using save as is and the document is renamed. However, the user cannot erase the old file.
Doing some digging I made sure the trust zone was enable for the network path and trusted locations on a network were allowed. They had already been configured.
I checked for the windows update that microsoft reported could fix this problem and it was not installed. I went ahead and tried the hotfix, but it would not run because of the missing update.
I tried changing permissions and ownership. This where it gets strange the user has full control enabled on the folder. On any other folder or file I can right click and view the security tab. However, on the excel files when I click the security tab a red line is displayed that says "This file is currently not available for use on this computer." If I try to make a security change on a whole folder any excel fil... Read more
To resolve this problem, reinitialize the cache of offline files. To do this, follow these steps:Click Start, type regedit in the Start Search box, and then press ENTER.
If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.
Locate the following registry subkey, and then right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
Point to New, and then click Key.
Type Parameters in the box.
Right-click Parameters, point to New, and then click DWORD (32-bit)Value.
Type FormatDatabase, and then press ENTER.
Right-click FormatDatabase, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor, and then restart the computer.
Taken from Gray "X" on network share folder icon
Hi Tech support guy,
Hope all are going fine here
i need a help to do some work in excell, well i will explain
i am having an excell file, where i updated all departments email contact details.
when i click on any particular email, i need to open lotusnotes on to:that particular email, cc: another email address, and a common temlpate in body of message, where i will fill manually,
i added the email address and subject in hyperlink , but i dont know how to go for other fields such as 'cc' and 'message of body'
Message of the body just contains
Please help me guys,
Thankyou so much in advance
it would be constructed like this.....
[COLOR="Red"]mailto:[/COLOR][email protected];[email protected]?[COLOR="Red"]cc=[/COLOR][email protected]&[COLOR="Red"]subject=[/COLOR]subjectmsg&body=Bodymsg
I am trying to create a template to save time when counting devices on drawings. However I guess I have too many formulas or the range to too big, because when I go to calc the workbook. It locks up for about five minutes. Any suggestions?
Read other 16 answers
I've been using this particular mileage template from Microsoft extensivley to record mileage used. It has the ability to record mileage, and keep a running total. Well, the running total stopped working. I know that its probably an easy fix, but I just can't figure it out. I'm using Office 2007. I thank any one in advance that is able to help me.
Read other 8 answers
Okay, so I've been assigned a task to make an excel sheet for our clients to use to input their invoice information. The file I'm creating will then be converted into pipe delimited and uploaded to a third party server [why they demand pipe delimited, I don't know]. The third party software is very particular about how it reads the file so I need all the cells to have the proper formatting.
I need to control what goes into a cell, for instance payment type may only be the 1 of 8 possible options. I can't trust the clients to fill in the spreadsheet correctly so what's the best way to make sure they can only enter proper formats into cells?
The follow thread to this will be, what's the best way to convert this file to pipe delimited. I was just going to write a macro that saved it in CSV then opened it in word and replaced the commas with pipes. All suggestions are welcome.
Read other 16 answers
is there any way to link a template with all the spreadsheets which are created from it, such that whenever i make changes to the template it will update all the spreadsheets at the same time. i am trying avoid having to change each spreadsheet separately as i refine the original design.
if there some other way to accomplish this without using a template, eg. using sheet1, sheet2, etc on the same spreadsheet, that would be ok as well.
Hello, please tell me what I am looking for. Once I have a name I'll dig into my reference books and the Help screens and it will make sense.
I would like to create a worksheet/template/style(generally one 8.5 x 11 page) that has unchanging text across the top, column A is filled with solid color. I'll use this as a "master" in creating 20 pages that have a uniform visual appearance.
The blank space down and to the right will have simple 8 or 10 row and 5 or 6 column "worksheets", or text. When I "print preview" I would like this material to center h/v. The text across the top and column A would not be impacted.
I don't know what Excel calls this sort of thing and so I'm at a lost to know what to study.
Read other 10 answers
I have constructed a template which contains my own customised toolbars which are very different to the usual toolbars and saved as an .xlt file in :-
Documents and Settings\user_name\Application Data\Microsoft \Excel\XLstart.
However whenever I try to use this template I get the usual toolbars and not my customised set.
This is causing me much consternation !!!.
I would be most grateful for any suggestions as I am obviously doing something very wrong.
Read other 16 answers
I am looking for a template to use in Excel that will allow me to sort my contacts/sales leads. Right now I am just saving all of my notes in various forms (word documents, excel, outlook contacts), and its a mess!! I was hoping there was an easy way to enter the information about the contacted company and the individual(s) within the company I have spoken with, and a space for tracking the status. My dream of course is to just run a report or show a graph of my progress. But as for now, I just really need a template to easily enter the information so that I can share it.
Does anyone know where to find one? I feel like I've Googled my heart out....
Thank you in advance!!!!
Read other 16 answers
Hi, I just thought I'd pose this question, I don't even know if it's possible.
I work at a t-shirt company and we create sheets for each order we do, showing all the sizes for each shirts, their totals, and then under that two pictures, the front of the shirt and the back.
Some of these designs we do quite a bit of and up until now the girl doing these has imported each picture by hand using corel draw and printing it out, and then filling in the totals by hand.
I thought it might be possible to create a template that lets her just type in the numbers of each size shirt that will automatically give her a total and, more importantly, I was hoping there was a way to have her be able to simply type in a letter (our t-shirt fronts are labeled by letter) of the front and have the program automatically put in the picture she was referencing when it prints out. I thought if I told excel where the pictures were and make the letter in that cell reference a specific one it would be possible. I don't know anything about excel, however, so I don't know how to go about doing it.
Is this possible? How would it be done if it is? Any help would be greatly appreciated.
Read other 11 answers
I am running Word 2010 on a PC, running Windows 7.
I cannot figure out how to make changes to the "normal" template and have those changes apply to old word files.
In old versions of Windows and Office, I used to be able to make changes to the normal template by going in through the Appdata, and the changes that I made would be reflected in both new documents created, and old documents when selecting "normal" as a text style. However, now I cannot even make changes to the normal template by going through file locations and saving changes.
I can only make changes to the normal quick style icon (by right clicking on "modify" and then applying all changes to "new documents based on this template.") However, this does not alter the "normal" quick style icon in files saved prior to making the changes to the normal template. How can I get my updated normal template to apply to all documents, not just new ones?
OR- maybe there is another solution...
The reason I need the normal template to apply to all documents is that in the new word, I cannot copy and paste and maintain source formatting (even when pasting special and selecting "keep source formatting".) The paste always takes on the destination style, and if the destination style has a "normal" template that is different from the source "normal" style, it automatically selects the destination style and WILL NOT keep source formatting. I have ... Read more
I have an Excel sheet that contains data per row (employee data). I want data contained in each cell of each row be put in a Word template (a work agreement)
I see something close to what I need here, but I tried to manipulate the codes for hours and achieved nothing.
Please find enclosed the Excel file and the Word template that I need. These are dummy files as forum rules rule out.
Thanks in advance for your assistance
Before we go into any macro development, have you tried the mail merge option in word?
With mail merge you need an excel file with your data formatted as a list - which you already have
then you need to define where you want each record in your excel file should appear in your word document - which you've already done although you should make sure that your list starts in row 1
in Word you need to associate the excel file with the Word template - in the Mail ribbon - Select Recipients/Use existing list and then navigate to where your excel file is an select it
then you need to enter the "variables" in your word document - I've done this or you in the attached
then you need to just select the record you want to run - Click on Edit Recipient list and click on the one you want
and click Finish and Merge and then either Print or Edit (if you want to save a copy)
Give this a try and see if it will suit your needs.
In Excel 97, when you choose "New" it would bring up an interface allowing you to choose templates. In XP, it brings up the sidebar on the right portion of Excel. Is there anyway to make it so Excel XP's "New" function will load with the old interface? (This interface still exists in the program)?
If this isnt clear enough let me know.
What about recording a macro that brings you into the "New" dialog box and attaching it to a button on your toolbar?