deleting data, keep formulas
I want to delete the data in a worksheet, but keep the formulas so tha
I have a worksheet pattern of formulas that I use frequently
elviejo41's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2356
View this thread: http://www.excelforum.com/showthread.php?threadid=39389
I don't know how large your spreadsheet is, but you could try changin
the setting to display Formulas (Tools>Options | View tab, in th
Win...Rules Wizard does not open.
I have a user that when he clicks the organize button and
then when that expands out he trys to click the Rules
Wizard button and nothing happens. Also Rules Wizard does
not show up in the Tools menu. He is using Outlook 2002
SP-1. Does anyone have any clues? Thanks,
...Form type in a public folder
need to create a folder on a server and have been told I have more
control over replication and where it is created if I use exchange
manager. This seems to be true and fairly straightforward except I do
not know how you create a folder to accept a particular type of form
The point you do that when you create one in outlook is when you select
"New" and you pick the form type from the drop down. I don't know if
you can change the form type for an already exising folder.
I do not mean the specific form type for a new item (eg ipm.task.custom
form) I mean the general...data validation #26
I have two cells in my spreadsheet where field personnel will enter data.
I'm using Data Validation, Allow Date, to control what they enter.
The cells are:
A1 Year Begin
A2 Proposed Year End
They will put the year they began in the "Year Begin", but I want to limit
what they can enter in "Proposed Year End" to no more than 12 years, that's
the max we allow them to take.
Under Data, I chose "between".
For "Start date" I entered "1/1/2004", just so they don't erroneously type
in previous years.
For "End date", what do...Filter of subfirm of sencond form
Hello all Expert
I have write vba code to filter the subform but i can't as below
-i have one form when click on button on this form
show another form that have subform so i want to filter this subform but it
is not working.
can you help me how to do it working?
...Data analysis by 2-dimensional data table + database
in an old Excel-manual (possibly way back to version 3) by Microsoft there
was an excellent example of a 2-dimensional datatable (in German:
Mehrfachoperation) with input variables based on database results. Now I
would need to apply this technique, but my old manual is lost, and I can't
figure out by heart exactly how this was done.
Does somebody still have an old manual from which to draw the model, or can
let me know the deatils of the trick?
Thank you in advance.
I think that you are talking about a cross-tab table....Exel 2002 freezes when opening sheet
Have office XP, windows XP pro, latest service packs.
When opening a word or exel document from the file/Open
menu and select previous documents opened at the bottom
of the menu the first time it takes forever and freezes
the machine while waiting, after that it will open OK.
...group & summarize diff rows of data that have something in common
I am trying to arrange a large amount of data (inventory) in 2 different
ways. 1) Group all identical parts into one row and 2) Group all identical
locations into one row. I dont know how to do this. I am dealing with over
3,000 rows. Any suggestions?
Depending on your workbook layout, you may be able to use a pivot table
to summarize the data. There are instructions in Excel's Help, and Jon
Peltier has information and links:
> I am trying to arrange a large amount of data (inventory) in 2 different
&g...Dexterity Runtime: You do not have permissions to open this file
So, I have a users that is getting:
"Dexterity Runtime: You do not have permissions to open this file"
I checked and I ensured that she has the same permissions on the network as
other users and she can get to all the files in the GP directory on the
server. I had the admin reset her password in Great Plains and that didn't
I had one of the other users log into her computer and it worked fine too.
Is this happening when first logging into GP? If so, it's typically a
Windows permission error on the reports.dic (usually this happens when it...Can a form with drop down menus search in other forms?
I am trying to design a database to where the switchboard will lead to a form
that has various drop down menus for searching purposes. Let's say that on
this form, one of the companies in the "Company Name" drop down menu is
Company A. I want for Access to pull all forms that have "Company A" in it.
So for example, I would end up with 1 record displayed out of 25. Is this
Well, you really search WITH forms; you don't search FOR forms.
Maybe this will help.
...opening excel from intranet ie6.0
I have a number of excel files I wish to share between
I can give them access to these files via our Intranet
using Internet Explorer 6.0.
My problem is that the excel files open up inside the
browser, not in excel.
I want user to click on the file in the Intranet IE6.0
and for the file to open in the Excel application (Excel
Any ideas / help welcome.
...Excel messes my data up
I am trying to run vlookup for about 5K cells from range of 20k cells.
Now the problem is that some of the cells include only numbers and some
both numbers and letters, like AB11002.
I also have empty spaces on the data so I have to run trim on both data
before running vlookup. Just after trimming both data vlookup runs
correctly, but if I "touch" any cell containing only numbers excel
propably converts it to number and at this point excel don't think
those two cells that before was equal are equal any more.
So how in the earth I could convert my mixed data in the format e...The disappearing form
In using Access 2007, I have a database with five joined tables. I want to
make a form, based on the "main table" and then four individual subforms.
This works fine for the first of the four subforms, but when I add the second
in design view, and then look at my handy work in Form View, all I have is a
blank, white display, none of the controls are visible. This is the most
complex form I have ever attempted and can not determine what is wrong.
If your form is blank, that generally means there was no data there to show.
Make sure your control sour...How to update the data of a combo box
In a form I have tab pages
One is for consultation data it is a subform link to consultation table. The
other page is Examen subform in which you have a combo box that will list the
consultations of a client.
The problem is when I add a new consultaion record for a client it does not
appear in the list. I have to select another client and then come back to the
preveous client to see the new entry.
For this combo I run Me.my_combo_box.requery on the current and load event.
Somehow this does not refresh or update or ??? my list.
What should I do ?
...Data Access Page 09-11-07
Good Morning Community,
Is there any way to include a search function on a Data access Page? I
have a file that I want to put on a Data access page that will be published
on a shared drive, the problem is that the file has about 1000 records and
to search through each one would defeat the purpose of putting the page up.
Is there anyway to include a search function that would jump to a particular
record as access does on its forms.
Thanks in advance for any response
Perhaps this sample database will serve as a starting point:
http://www.cadellsoftware.org/SampleDBs.htm#FilterDAP...BOM print in graphics mode missing data
We are using GP 8 SP 2. When we print a BOM in text mode, everything prints
fine but it graphics mode, each page is missing several lines of data as if
it expects the page to be longer than 11". Does anyone know of a fix for
...how do I link a text box on a chart to a specific data point?
I have a text box in a chart that I want to move with the data, as additional
data is added to the chart. For instance, if the datapoint is January 5,
2008, as I add additional days, I want the text box associated with the
January 5, 2008 datapoint to move with the graph.
Text boxes don't track with the data. Replace the text box with a Data
Label. Select a single point in a series that is near the location of the
text box. Choose Format, Selected Data Point, on the Data Labels tab turn on
Value. Click OK. Select the data label and type the text that was in the
Text box. ...Exchange 2003 Forms Logon
I am trying to have exchange 2003 view forms when using the webmail client
to logon, I set it to use forms in exchange system manager, but upon
login.... no forms :/ just a dialog box to logon...
Can anyone help?
thanks alot in advance
Rudi Groenewald wrote:
> Hi there....
> I am trying to have exchange 2003 view forms when using the webmail
> client to logon, I set it to use forms in exchange system manager,
> but upon login.... no forms :/ just a dialog box to logon...
> Can anyone help?
I guess you mean Forms-based Authentication? Are you u...Locking Fields in an Editable Form
I created a form that has the Allow Edits selected as Yes. But I only want 2
fields in the form to be editable, the remaining other fields I'd like them
to be locked. Is there a way I can lock the other fields so that it's not
changed? When I try to change the field property for Locked as Yes, it locks
the field so that when I enter any new records it will not allow me to input
data in that field. Can anyone suggest how I can modifiy my existing form so
that it locks most of the fields after it's saved but allows edits to
specific fields when going back on a record?
Th...Unable to open Exchange Systems Manager
When I double-click on the ESM on the desktop. I get the following error
Error Message 1:
The system cannot find the file specified
ID no: c007002
Exchange System Manager
Error Message 2: (This message appears after clicking on OK from message 1)
Microsoft Visual C++ Runtime Library
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
Running Exchange 2003 with Windows 2003
"=?Utf-8?B?TWlrZSBDaHVuZw==?=" <MikeChung@discussions.m...Unable to open excel file #2
I have problem openning an excel file from windows explorer or from my
desktop. However, when I open the excel program and open a file
manually(File-Open----) everything works fine.
I get an error message that the file could not be located. I noticed
that it adds .xls to every word separated by space. For example:
My file is in C:/Shared/Folder/test.xls,
it tries to open: C:/Shared.xls then Folder.xls then test.xls
Message posted from http://www.ExcelForum.com/
I think the steps below will solve this problem:
1. Exit Excel
2. From the Startmenu, cli...Open Puiblisher Document Without Program Installed
Is there a snap-in or some way to view a Publisher 2003 document without
having the Publisher software installed? I know there is a viewer for
Powerpoint slides and thought maybe there is something similiar for
Publisher? I have done some searches and found nothing. Thanks in advance
for any info.
No, there isn't a Publisher viewer. Have your sender convert the publication to
a PDF or a picture. There are free PDF converters around.
You can download a trial version of Publisher 2007, when the trial runs out it
will serve as a viewer.
http://office.microsoft.com/en-us/publisher/FX...Report Writer, Blank SOP Forms & MBoM Revision Levels
I am trying to add the revision level listed in table BM010415 of the
Manufacturing Series to the Blank SOP Forms used in Dynamics GP. I am
frustrated by the lack of capacity to relate GP Tables to Manufacturing
Tables in the Report Writer. Can anyone offer any help? (Without using
Modifier dependant VBA.)
To go into further detail, I can link from the Manufacturing Series into
standard GP tables; but I can't link from GP into Manufacturing, which forces
the Manufacturing Tables to be primaries and inhibits the ability to reach
into Manufacturing. I can add GP Data into...unable to open information store
After a recent power failure, where the exchange server was not shut down
properly and just died, I now have users, that used to be able to open other
users inbox to read the emails, now not able to open these inboxes.
the message is unable to open information store.
The same also applies to callenders, but this is not happening to everyone,
as I can still access other peoples folders.
...Import XML data in Excel XP Professional
I have a pretty well-formated XML data file and a well
designed Excel file (.xls) served as my report template.
I would like to import this XML data file into my Excel
template. So, the Excel Template will do the Totals and
subtotals of the XML data for me. How do I do so in
Excel XP Professional version?
Thank you sooooooo much~~~~