A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using worksheets at a form but formulas are not working



 
 
Thread Tools Display Modes
  #1  
Old November 15th, 2009, 01:35 AM posted to microsoft.public.excel.setup
evilthorne
external usenet poster
 
Posts: 8
Default Using worksheets at a form but formulas are not working

I made a "form" up with pull down menus and named columns. I'm hoping to use
this as a form system for customers. My problem is that when I copy the
orignal worksheet and put it in a worksheet in the same workbook the formulas
keep refering back to the copied worksheet.

How do I make the formulas only refer to the worksheet that the data is in?
I would like to be able to just keep one orignal and then copy and rename
that worksheet for every new customer.

Thanks

  #2  
Old November 15th, 2009, 04:00 PM posted to microsoft.public.excel.setup
FloMM2
external usenet poster
 
Posts: 189
Default Using worksheets at a form but formulas are not working

evilthorne,
Once you have your worksheet setup the way you want it. Columns width, row
height, drop down lists, and formulae are all set. Save the workbook as a
template.

Select "File", select "Save As". In the window that pops up, at the bottom,
select the down triangle in "Save as type:". The last selection is "Template
(*.xlt)", this is what you want. Make sure you name it something easy to
recall, and where you save it to. The default is to save it in a "Templates"
folder, this may or may not be where you want it.
hth

"evilthorne" wrote:

I made a "form" up with pull down menus and named columns. I'm hoping to use
this as a form system for customers. My problem is that when I copy the
orignal worksheet and put it in a worksheet in the same workbook the formulas
keep refering back to the copied worksheet.

How do I make the formulas only refer to the worksheet that the data is in?
I would like to be able to just keep one orignal and then copy and rename
that worksheet for every new customer.

Thanks

  #3  
Old January 4th, 2010, 04:32 AM posted to microsoft.public.excel.setup
evilthorne
external usenet poster
 
Posts: 8
Default Using worksheets at a form but formulas are not working

Thanks I'll try that as well. I ended up just removing the names and using
cell values and it fixed it that way as well.

"FloMM2" wrote:

evilthorne,
Once you have your worksheet setup the way you want it. Columns width, row
height, drop down lists, and formulae are all set. Save the workbook as a
template.

Select "File", select "Save As". In the window that pops up, at the bottom,
select the down triangle in "Save as type:". The last selection is "Template
(*.xlt)", this is what you want. Make sure you name it something easy to
recall, and where you save it to. The default is to save it in a "Templates"
folder, this may or may not be where you want it.
hth

"evilthorne" wrote:

I made a "form" up with pull down menus and named columns. I'm hoping to use
this as a form system for customers. My problem is that when I copy the
orignal worksheet and put it in a worksheet in the same workbook the formulas
keep refering back to the copied worksheet.

How do I make the formulas only refer to the worksheet that the data is in?
I would like to be able to just keep one orignal and then copy and rename
that worksheet for every new customer.

Thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.