Updating 09 Spreadsheet to 2010

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I have a complicated 2009 spreadsheet. Except for the data, all the formulas and column and row headings will be identical for 2010. Now that the spreadsheet is complete, is there an easier way to use it as a template for 2010 then to save as 2010, then manually delete all the data entries leaving everything else intact? <br>
Thanks in advance, <br>
Alan
0
alanl3
12/27/2009 4:54:11 PM
mac.office.excel 1146 articles. 0 followers. Follow

2 Replies
641 Views

Similar Articles

[PageSpeed] 16

There's no "easy" way as far as being able to just copy/paste or Save As
everything but the values you don't want to retain. A template includes
everything that's in the file being used as the model, so that would present
the same problem, but here's one option to try:

Select & copy the content of the 2009 sheet, paste to the new sheet. In the
new sheet select & copy a range of cells that contain last year's values
(not your formulas), leave those cells selected & go directly to Edit> Paste
Special. Select Subtract in the Operations, then OK. Repeat for each
contiguous range of cells that contain prior values.

Alternatively, to remove the content brought forward from last year's sheet
use Edit> Clear - Contents.

Neither is any faster than just deleting the unwanted values but at least
each ensures that the formatting will be retained. If you intend to follow
the same model next year make sure to create your worksheet template before
you start to accumulate any data.

HTH |:>) 
Bob Jones 
[MVP] Office:Mac




On 12/27/09 11:54 AM, in article 59bafd9d.-1@webcrossing.JaKIaxP2ac0,
"alanl3@officeformac.com" <alanl3@officeformac.com> wrote:

> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> I have a complicated 2009 spreadsheet. Except for the data, all the formulas
> and column and row headings will be identical for 2010. Now that the
> spreadsheet is complete, is there an easier way to use it as a template for
> 2010 then to save as 2010, then manually delete all the data entries leaving
> everything else intact?
> Thanks in advance,
> Alan

0
CyberTaz
12/27/2009 6:42:20 PM
Thanks Bob, <br><br>That's just what I'll do. <br><br>Alan
0
alanl3
12/27/2009 8:43:12 PM
Reply:

Similar Artilces:

Argg! How do I find an invalid ext reference when updating links?
I get the message invalid ext reference when I am trying to replace a link. I have deleted some of the sheet of the feeder sheet but I thought I had already updated those where the reference had been deleted? How can I get round this problem? Thanks a lot Adam Hi Adam See if there are any broken links in menu Insert > Names > Define. HTH. Best wishes Harald "Adam" <Adam@discussions.microsoft.com> skrev i melding news:E1601C56-AFF2-479A-AB5A-D21744912EB2@microsoft.com... > I get the message invalid ext reference when I am trying to replace a link. > > I h...

how to create mail merge from excel address spreadsheet
Please help me to run mail merge from excel address spreadsheet. I have looked for hours through "help" on computer but can't find how to get this to print out envelopes from my spreadsheet automatically. I have Word 97 Office. Appreciate a step by step guide. Thanx. I've never printed labels from Excel (so I can't help you), but perhaps MVP David McRitchie's website section on Mail Merge can assist you. His website is a great resource: http://www.mvps.org/dmcritchie/excel/mailmerg.htm HTH Jason Atlanta, GA >-----Original Message----- >Please help me ...

Export Data and populate existing Excel Spreadsheet Fields
Good Afternoon. I hope someone can help me with this. I working on a project for a client in which they have an existing Excel Spreadsheet that has about 8 fields with about 700 rows of data. I have another user that is storing data into a Access database, and I want this data to be able to export and populate the existing fields on the Excel spreadsheet. How do I do this? There has got to be a way to do this without writing VB code. I am a Network admin, not a programmer so I need help with this one!! Thanks, Wes H cut & paste? Wesley, If you want to manually select records ...

how to embed macro into new/create spreadsheet from outside of EXCEL?
I'm want to create a workbook that contains an auto open macro that I can then email to a business user. However, this must be done outside of Excel. In other words, I want to create a Workbook generated from outside of Excel like a downloaded .CSV file that has an Auto_Open macro already built into it so I don't have to open the workbook just to build the macro into it. Any help much appreciated. Thank you, Stuart ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** The .csv files...

Office 2007 Compatibility Update
I've downloaded the Office 2007 Compatibility Update, but it's an .iso file. I've tried burning it to a CD, but it still is an unrecognizable file format when I try to run the .iso file from the CD. Is there something I'm missing to make this work? -- Brandon ================== Presentations Direct - http://www.presentationsdirect.com > Binding Machines http://www.presentationsdirect.com/binding-machines/gbc-binding-machines.asp > Laminators http://www.presentationsdirect.com/laminators/gbc-laminators.asp > Paper Shredders http://www.presenta...

Setting tab colours on Excel spreadsheets (for Excel 2000)
I've received a file from a colleague who's using Excel 2003. She has set colours on the tabs of each sheet in the file. However, I'm using Excel 2000 and I cannot see any of the tab colours. Any awesome tips to solve this problem (other than installing Excel 2003)? Thanks! Not available in 2000, came in with XP(2002). -- HTH Bob Phillips "S" <S@discussions.microsoft.com> wrote in message news:049E3593-1088-4E36-9A0E-978DF3989418@microsoft.com... > I've received a file from a colleague who's using Excel 2003. She has set > colours on th...

Evaluate File for Last Updated Date
I want to have my macro code determine the date a file was last updated and then from there, decide whether or not to open it. What I don't know is how to access the file's property that returns that date it was updated. If I could just use an "If" statement to say something like this, in principle: If Filename.DateUpdated >= Today() - 1 Then Workbooks.Open Filename End If The goal is to only open files that have been updated within the last two days. Is this possible? Using document properties. IF Filename.BuiltinDocumentProperties("Last S...

Office X 10.1.2 to 10.1.5 updates
Each time that I'm trying to install these updates, I get the error 11002:2'-15. Nothing is running even my anti-virus. Does somebody have an answer. Thank you On Mon, 23 Feb 2004 21:51:05 -0500, Doggy wrote (in message <013f01c3fa81$0c225e50$a401280a@phx.gbl>): > Each time that I'm trying to install these updates, I get > the error 11002:2'-15. Nothing is running even my anti-virus. > > Does somebody have an answer. > > Thank you It's been said, and it seems to have worked for me, that you need to have all internet access disabled. Tim M...

Is this still a bug in 2010?
As this older post points out, if after receiving items from vendor you create a Returns Transaction Entry of type Return which is what you need to do BEFORE you receive the vendor invoice (because by default this transaction credits inventory and debits accrued payables NOT AP.), when you do receive the vendor invoice, the Purchase Invoice Entry screen does not see the return. It only looks at the PO and as Sheila points out is a bug. The system should see the returns otherwise the person entering the invoice will not know we returned items and will pay the full invoice. Here is ...

aggregate calculation works in select query but not an update quer
The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try to call this query from a Macro on my form, I get error (-20324) repeated the number of times that there are records in the query. It was designed to go into a table of price breaks & decide whether the quantities being ordered meet the price breaks. It then takes either that adjusted price, or the original price & populate the values into a table. Select Query: SELECT QryBOMDetails2.ParentBOMID, QryBOMDetails2.B...

How force table update when no bound field updated?
I have a main form with a 'Balance Due' field. There are two balance due controls, one unbound (displayed) and one bound (hidden). I also have a subform which is a continuous form containing payment data. When payment details are entered or changed, the balance due on the main form and in the bound table needs to be updated. The total of payments is summed in the subform footer and the balance due (unbound control) refers to this subform total. In main Form BeforeUpdate, I copy the unbound balance due to the bound balance due. The problem is that when only payment data is...

Excel spreadsheet #2
I am beginning an Excel class and I can not figure this out. Could someone please help me figure out how the formula for this is suppose to look? If the content of cell C4 is Bronze, then insert the word None. If the content of cell C4 is Silver then insert $3,000. If the content of cell C4 is Gold, then insert $5,000. If the content of cell C4 is Platinum, then insert $10,000. I would be very much appreciatvie. Thanks On Apr 13, 9:15=A0am, jslb...@bulloch.net wrote: > I am beginning an Excel class and I can not figure this out. =A0Could > someone please help me figure out how th...

Apply this internet update
--sibajqbe Content-Type: multipart/related; boundary="ivvzftyxvkbualflp"; type="multipart/alternative" --ivvzftyxvkbualflp Content-Type: multipart/alternative; boundary="noylsyxkwuwc" --noylsyxkwuwc Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three new vulnerabilities. Install now to help mainta...

Printing Excel Formulas without file paths updating
I have numerous spreadsheets that need to be printed showing the formulas. However, some of the formulas are derived using a link to a different spreadsheet (not created on our network). When we open the sheet and choose to not update the links, the spreadhseet opens, and when we view the formulas they appear. However, the file path for some of the formulas also appears using my network information (e.g. c:\documents and settings\name, etc....). Is there a way to retain the original path information? Thank you. ...

Users missing from Advanced Permissions after TM Group Update
I have noticed that each time the Team Members security group is updated, users associated to that group get removed from the Site Settings > Advanced Permissions list of users. It is a seemingly random bunch of users that get removed. And as we add more users to the system, the amount of users that are removed from Advanced Permissions seems to grow when an update is applied. I have noticed that I do receive an error for the group synchronization. It never completes. This definitely seems to be a contributing factor. Is this happening because I am logged in using my pe...

How to update Access MDB via XML Schema?
I have an Access MDB that I have created via VB .NET, thus it is an emply database. I have an XML Schema file (.XSD) that has the schema for the database, how do I get the XML Schema into the Access MDB? I have code that loads, or seems to do so, the XML Schema into a DataSet object, but how do I update the Access MDB with this DataSet Object? A code example if you please. ...

2010 FIFA World Cup South Africa XBOX360.exe (7/7)
=ybegin part=7 line=128 size=1593902 name=2010 FIFA World Cup South Africa XBOX360.exe =ypart begin=1497601 end=1593902 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-��...

DPM 2010 Backup of 2008 R2 HyperV CSV
Hello, I am attempting to backup several hosts on my HyperV Cluster. I am running 5 2008 R2 machines that are using a CSV located on an Equallogic (Dell) PS100. When I perform the first backup everything seems ok, however as soon as it attempts a consistency check I run into problems. The error I see in the logs on the machine running the VM is "Error 0x80070490 opening SNMP connection to \\.\PHYSICALDRIVE2 (0-8a0906-ee61d2801-101008a65674ae1c)." I have talked to Equallogic, and initially it sounded like perhaps using their Hardware wasn't supported, but it l...

On Update Cascade. Should I use it?
Hello, When should I cascade on update or on delete? On delete I am cascading all relationships not including the ones with Lookup tables. But should I use it on Update? Thanks, Miguel "shapper" <mdmoura@gmail.com> wrote in message news:5049af1f-507d-4c73-a10f-a70013b7e7e2@s9g2000yqd.googlegroups.com... > Hello, > > When should I cascade on update or on delete? > > On delete I am cascading all relationships not including the ones with > Lookup tables. > > But should I use it on Update? Cascading should be done whenever you wa...

Windows Update Error 80080005
I am running Vista Home Premium 64-bit. I keep getting this message: "Error(s): Code 80080005 Windows Update encountered an unknown error." I have been getting this for about 2 months and I have ignored it untill now. I think it all started when I tried to update to SP2. Please help!! What anti-virus application or security suite is installed and is your subscription current? What anti-spyware applications (other than Defender)? What third-party firewall (if any)? Has a(another) Norton or McAfee application ever been installed on this machine (e.g., a free-tri...

No Baseline after each update
Hi, In our PWA site (MS project 2007), we have graphical indicators to measure our progress. When we create a project through Microsoft project professional we set base line (tools-tracking-set baseline) and then we publish it. In our project center view (in /PWA site) we can see the graphical indicators. The problem is when we update a task through PWA site (change percentage from My task or anything that needs save and publish again) it requires “save & publish” to get applied in project center. After we do “save and publish” through edit project properties we lose our...

Append/update Query with two sources
There are many postings dealing with append queries and they have helped a great deal with the other one I was working on, but this one is different. I am wondering if it is possible to run an append query from code with two different sources for the data. There will be three values written to the table, but two are coming from a form and one is coming from a query. Background: The table is an associative entity with three values all set at the primary key and duplicates allowed. ContactID CompanyID LocationID All three values are on the form, and would be used straight from the form for ...

Error Code 0x80200010 12-10-09
I need help downloading updates, machine refusing using error code 0x80200010 -- Wayne Please always state what OS you're & service pack Also, could you supply some information on what your firewall is, anti-virus, other R-TP programs, etc? http://support.microsoft.com/kb/555375 BG_E_NETWORK_DISCONNECTED 0x80200010 The network card is inactive or disconnected. All jobs are placed in the BG_JOB_STATE_TRANSIENT_ERROR state Try stopping and then re-start the BITS service. You receive the error 0x80200010 when you try use the Windows Update Web site or ...

Parameter Queries 09-19-07
Access 2002 Is there a way to not only have a prompt for values to a criteria, but also if the user don't put in a value for the parameter, then it doesn't use that particular criteria? From what I understand, when a user leaves a parameter blank, it returns as a "NULL" value, which then causes no records to be returned. I like to see if we can get around this issue without having to create multiple queries, as I see this unuserfriendly if there is no way to get around it other than having to create either multiple queries or having to custom code and use recordsets...

Spreadsheets printing as a mirror image
Every file printed comes out as a mirror image ? Consider updating your printer driver... /i. "Lenny Soulfish" <anonymous@discussions.microsoft.com> wrote in message news:04e901c3a920$c2091a90$a001280a@phx.gbl... > Every file printed comes out as a mirror image ? Extract this font to your c:\WINDOWS\Fonts\ (or C:\WINNT\Fonts\) directory and the open Word. You should be able to select it from your font menu now and type whatever you want in reverse. Attachment filename: revfont.zip Download attachment: http://www.excelforum.com/attachm...