Here's the deal.
My company decided to update the Office from 2007 to 2010. We use Excel mostly to processing economic data, and develop some vba program to do that. The problem is we have already developed a lot of vba program, and we are not so sure wether this updating thing will destroy some of them.
So now I need a list of the differences between 2007 version and 2010 version. This list should include every detail of both programing changes and application changes.
I have been looking for this kind of documentations on official website for more than a week, and I only get some general descriptions at present.
Is there anybody has the documentations like this, or knows the url of web pages contain this kind of information? Please share them.
Thanks
Just testing out porting some 2010 reports into 2013 and found that Excel functionality has changed just enough to break them. Curious if someone might point out a solution:
1) Report is pulling from a SQL database and/or OData feed.
2) I have projects along the Y axis.
3) I have standard stage gates along the X axis.
4) Each cell should depict the date upon which each project will hit the stage gate.
In 2010, I simply set up the PivotTable and then set the cells to display the "Max" value of the date. After formatting the cell to appear as a date, it worked just fine.
In 2013, I get a message that I can't use the Max calculation with date fields in the pivot table. Effectively, this breaks the report. Is there an easy fix to this or do I need to break out some sort of combination of v and hlookups?
Thanks in advance....
Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
Microsoft Word - Word Printer problems |
| Posted: 28 Oct 2012 10:34 AM PDT Just recently, documents that are in word, neither new or old, will print. The printer acts like it's printing, but it just shoots our blank pages. Or maybe just the heading will print. Have totally reinstalled my hp printer. So don't think that's the problem. It prints everything else fine. |
| I cannot open a word starter file. Posted: 27 Oct 2012 03:48 PM PDT I cannot open a word starter 2010 file. Error message "click-2-run configuration failure''. Have been using the program since purchasing pc. It came preloaded. I need to access my documents but cannot. What to do? My OS is Windows 7 - 64 bit. I do not want to upgrade as I do not need the full office program. Is this something that expires? I certainly hope not! |
| How do I change the number of minutes until the computer shuts down? Posted: 27 Oct 2012 12:39 PM PDT Could someone tell me how to change the number of minutes until the computer shuts down automatically? It shuts down after only a few minutes of inactivity. I want to lengthen that time by a few minutes. |
| Posted: 26 Oct 2012 11:39 AM PDT hello,Please,currently I have tried to uninstall a program(trial version) of office 2010 home and student from my computer but it says I should contact microsoft for help. thanks |
| Posted: 22 Oct 2012 02:40 AM PDT Hi Need to permanently remove 'track changes' from a document (word 07) I did following steps goes to turn the feature off, saves the document and finds that 'track changes's is re-enabled! i've googled this issue and attempted on my end to replicate the steps and follow the solution; and it is not working for her. when she opens the document, track changes is re-enabled! |
| Word 10 - Proofing English Pack will not load. Spell check will not work Posted: 21 Oct 2012 08:57 PM PDT I have uninstalled and reinstalled the English language tool multiple times. My Office is x32 and that proofing pack appears to load properly. I go to File, Options, and Language and proofing shows as NOT INSTALLED.
I do not know what to do to fix this. I cannot find a similar report on any website.
I'm running Windows 7 with all updates. Office has the latest SP also updated
Thanks for your help |
| Problem merging the split documents in MS Word 2010 Posted: 21 Oct 2012 08:29 PM PDT I got a draft letter of eight pages from a known source in ms pad. I opened it in ms word 2010. By mistake, contents of one page got split into two pages. I would appreciate if you could let me know as how to merge the same contents into one page? |
| Why do I have to pay for Word 2007 after installing Office 2010? Posted: 21 Oct 2012 03:14 PM PDT Original Title: Why am I now being told I have to pay for word 2007 after installing Microsoft 2010. I don't understand??? I am also, now, very angry over the rigorous process to get this far!! Get someone to answer my questions immediately!! I am quite upset at the entire process.. I want to know why I am being charged for the exact same word program (2007), why I was not told about it, and where my old program went because I want to access the internet through word (and not on a trial basis). That is what I thought I was paying for!!!!! I also prefer speaking to a live individual, particularly when it comes to money! Please provide me with a customer service phone number. |
| You are subscribed to email updates from Office Forum - Answered Threads, Microsoft Office Word To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
Microsoft Works - Problem installing Microsoft Works 2000 |
| Problem installing Microsoft Works 2000 Posted: 04 Jun 2004 03:44 AM PDT The only thing I can think of is maybe the CD's are damaged and some things might not install. Maybe scratches on them? Other than that I can't think of anything. version, can you answer is |
| Posted: 03 Jun 2004 02:06 PM PDT Thanks..do u know if the ability to save as rtf is already part of works 2.0 or do i have to install something. I am helping a friend on their computer so don't have the machine with me 24/7 thanks "A.A. Fussy" <com.au> wrote in message news:c9p05k$331$austar.net.au... |
| Merging Works Database into Word Envelope Posted: 01 Jun 2004 08:16 PM PDT In my version of Word(Word 2000) you can save a document in Works format. If you do that, you should have no problems with the envelope function of the word processor that comes with works. James. |
| Converting MSWorks Database to Access Posted: 01 Jun 2004 01:04 PM PDT Thank you, I will |
| Posted: 01 Jun 2004 12:44 PM PDT Thanks, Kevin. Let's hope MS can be inspired to make it work - as it did very well in WORKS 4.5 http://www.btinternet.com/~kevin.james1/index.htm message side sets |
| Posted: 01 Jun 2004 07:51 AM PDT Hi Craig, That has yet to be announced, by Microsoft HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2004 Website & FAQ: http://www.btinternet.com/~kevin.james1/index.htm <microsoft.com> wrote in message news:16b5301c4482a$39e6cd70$gbl... |
| Posted: 31 May 2004 06:50 PM PDT There is a label with 3 barcodes and several long numbers. I tried 3 different numbers as Product Id, and none of them worked. Just now I noticed there is another number I didn't try. Guess had better try that one. Web site could have mentioned the label and told which number it is. That woulda saved me a lot of time. That's assuming this other number is the one. Microsoft works 2004 & wrote in message All I drive. require a |
| Posted: 31 May 2004 01:12 PM PDT >I try the support site of your Family Tree Program. This Thank you for your suggestion. However, I don't think it has to do with FTM but rather with the Search engine. When there is a file containing certain words, no matter what the format of the file, Search should be able to find it, don't you agree? Pat |
| Posted: 31 May 2004 09:42 AM PDT Hi Dave, Perhaps the following knowledge base articles, the first one references error messages. http://support.microsoft.com/default.aspx?scid=kb;EN-US;242323 Works: Utilities to Help with Troubleshooting Works http://support.microsoft.com/?kbid=297061 Hope this helps, Ken "Dave G." <microsoft.com> wrote in message news:1603201c44739$201e2150$gbl... I tried both installs and it still won't copy new files. |
| Posted: 31 May 2004 08:52 AM PDT Sue, My previous instructions need modifying ! Go to Form Design View. Create a new field ... Go to Form View Resize field etc.... Copy and paste picture ... HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2004 Website & FAQ: http://www.btinternet.com/~kevin.james1/index.htm "Kevin James - MSMVP Works" <org> wrote in message news:phx.gbl... |
| Posted: 31 May 2004 01:59 AM PDT "Syed Farzan Faisal" <net> wrote in message news:... link pops the done |
| birthdays, address book, calendar 7.0 Posted: 30 May 2004 08:02 PM PDT Re: Any other ideas. Reply: No Ken "Duyen" <com> wrote in message news:16dbd01c44834$96bacba0$gbl... Hi Ken, I've uninstalled the update and am still having the same problem. My address book saves all birthdays as Jan 01. Any other ideas? Thanks, Duyen Update Q330994 calendar reverted to address book. As I book because after |
| Posted: 30 May 2004 07:06 PM PDT On Sun, 30 May 2004 19:06:58 -0700, "Jennifer" <microsoft.com> wrote: Jennifer, you'd be best off following Kevin's advice about checking your settings, and then stick with the latest updates of version 4.5 - that's the best version of Works ever -- I've used it ever since it came out, through Windows, Win98, WinME and now WinXP. Mad? Subscribe to VITUPERATIONS - you'll get madder, and you'll like it! |
| Posted: 28 May 2004 03:03 PM PDT You are correct. Thank you so much for solving my probem. I selected "no watermark" and the background was gone. Don't know what I (and others) would do without you helpful folks out there that gives their time to assist others. Thanks again. along being problem http://www.btinternet.com/~kevin.james1/index.htm |
| You are subscribed to email updates from TextNData Forums - Microsoft Works To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
RPM install - Forums Linux |
| Posted: 09 Feb 2004 11:48 AM PST On Mon, 09 Feb 2004 15:02:19 -0600, Digitlcoup <bar> wrote: --------------------------------- O.K. Thanks. I'll check it out. Jack |
| need help with debian network setup Posted: 09 Feb 2004 11:26 AM PST Hallo walterbyrd (<com>) wrote: Check /etc/network/interfaces. Check if the module is loaded (lsmod). Install etherconf, or, if it is installed, run dpkg-reconfigure etherconf best regards Andreas Janssen -- Andreas Janssen com PGP-Key-ID: 0xDC801674 Registered Linux User #267976 |
| How to install rpm without using rpm itself Posted: 09 Feb 2004 09:44 AM PST Chris F.A. Johnson wrote: thanks, that works! markus |
| Posted: 09 Feb 2004 09:41 AM PST ["Followup-To:" header set to comp.os.linux.portable.] (That means that you should look for this post in comp.os.linux.portable and continue the thread there. A number of PCMCIA gurus hang out there, so your question is more likely to get answered there.) On 9 Feb 2004 09:41:30 -0800, David Jackson staggered into the Black Sun and said: The card may well be a LoseModem; there's not enough information in your post to tell. Check http://catb.org/~esr/faqs/smart-questions.html for general advice on asking good questions on Usenet. It's not necessary to end every sentence with a question mark? Anyway: yenta_socket is the module that drives the PCMCIA card socket in your laptop; you need that module loaded in order to do anything with any PCMCIA cards. PCMCIA cards also have other card-specific modules that are needed; my old NE2000-compatible card used pcnet_cs, and my CompactFlash and SmartMedia PCMCIA adapters use ide_cs. The best way to find out if your card is supported by anything or not is to plug the card in, do "cardctl ident", and post the output from that command in a followup to this message. The exact model# of the card may also help. Or you can look up your modem in the LoseModem Database at http://freewebhosting.hostdepartment.com/g/gromitkc/winmodem.html , if it's there and marked as "WM", it won't work. HTH, -- Matt G|There is no Darkness in Eternity/But only Light too dim for us to see Brainbench MVP for Linux Admin / mail: TRAP + SPAN don't belong http://www.brainbench.com / Hire me! -----------------------------/ http://crow202.dyndns.org/~mhgraham/resume |
| Posted: 08 Feb 2004 10:21 PM PST Vicious Vogon wrote: Thanks. Anyway, I found slideshow screensaver minutes after I posted the question. GVK -- Happy Hacking!!! |
| cannot connect ssh to Linux from Windows using putty or cygwyn Posted: 08 Feb 2004 08:09 PM PST What exactly did you do? IP Could not connect Network cannot connect No But please see the following - as I got some respionse from another newsgroup OK I have ssh working but need help still: `iptables -L INPUT` target prot opt source destination `iptables -L RH-Firewall-1-INPUT`. target prot opt source destination ACCEPT all -- anywhere anywhere ACCEPT icmp -- anywhere anywhere ACCEPT ipv6-crypt -- anywhere anywhere ACCEPT ipv6-auth -- anywhere anywhere ACCEPT all -- anywhere anywhere ACCEPT tcp -- anywhere anywhere REJECT all -- anywhere anywhere I stopped /etc/init.d/iptales stop - ssh worked But when I turn on it stops. What am I missing. I have no idea about iptables. |
| Posted: 08 Feb 2004 08:09 PM PST Thanks all for ur suggestions: This is what I did: Linux: /etc/hosts Added all the machines on my n/w XP: Added all the machines on my n/w Disabled the Personal Firewall Now I can ping using IP or hostnames between Windows and Linux. NOW: Can u help to move to bind or DNS as someone suggested - as I dont want to keep updating my setup as and when I add any new machine. That will help a lot. |
| Horwath URL UPDATE - was I say we should give him what's Posted: 08 Feb 2004 04:38 PM PST mshortridge wrote: nothing it's spammed garbage, and you could have at least trimmed it out of your reply. -- ====+====+====+====+====+====+====+====+====+====+ ====+====+====+====+ "Liberty isn't a thing you are given as a present. You can be a free man under a dictatorship. It is sufficient if you struggle against it." -- Ignazio Silone - "The God that Failed" (1950) |
| Posted: 08 Feb 2004 02:42 PM PST Travis 'Usenet' Bickel wrote: yes http://uranus.it.swin.edu.au/~jn/linux/ext2ifs.htm http://uranus.it.swin.edu.au/~jn/linux/explore2fs.htm http://sys.xiloo.com/projects/projects.htm#ext2fsd http://www.ext2fs-anywhere.com/ -- Mauriat (www.mjmwired.net) ---------------------------- Remove 'NOSPAM' to email me. |
| Correct modeline for 1920x1200 screen? Posted: 08 Feb 2004 01:14 PM PST "Jim Kroger" <com> schrieb Since you post also to alt.os.linux.suse, I assume you use SuSE. Using sax (or was it sax2?), I chose LCD screen, then it offered me various resolutions. For my (now oldish) Inspiron 7500 I chose 1400x1050. Works fine ever since. There was no need to fiddle with modelines, a concept I never quite gathered. HTH Martin PS: If everything else fails, I'd recommend you to try using Knoppix and its built-in excellent hw detection & configuration. Just copy the Knoppix-XF86Config file to your existing setup. That's the way I would go now if I couldn't do with the built-in tools. |
| software to improve quality of mp3s Posted: 08 Feb 2004 12:38 PM PST GVK wrote: You're not likely to see much improvement. By bad quality, do you mean poor sound due to bad encoding or too low a bit rate, or hisses /pops etc? You may have more luck with removal of hisses / pops etc, but if it's just because the file has been compressed too far, I don't think you'll see much improvement, after all the problem is that MP3 is a lossy format, and lost audio information is gone for good. I've heard good things about GWC (Gnome Wave Cleaner, see: http://gwc.sourceforge.net/ ) - give that a try and see what it can do. Good luck! Cheers Dave P -- David Precious http://www.preshweb.co.uk/ |
| Posted: 08 Feb 2004 12:18 PM PST In comp.os.linux.advocacy Travis 'Bailo' Bickel <net> wrote: /me boggles. /me truly is gobsmacked. riiiiight, you're SO experienced in linux that you didn't realise you could switch from X to command line wityh ctrl-alt-F1::F6. You'll be saying you don't know how to get back with ALT F7 next. Then you'll be claiming you don't EVEN know how to start extra X sessions on F8, F9, F10 etc and switch between them. |
| Posted: 08 Feb 2004 05:32 AM PST Specialk <address> wrote in message news:<L5sVb.7$abs.net>... I already did that. when I reboot I got the updated lilo menu. When I chose the new image (2.6.2), the computer reboots! |
| Posted: 07 Feb 2004 11:13 PM PST In article <athghost7038suus.net>, The Ghost In The Machine <athghost7038suus.net> writes: It shold work under XFree86 4.1. (II) ATI: ATI driver (version 6.3.6) for chipsets: ati, ativga (II) R128: Driver for ATI Rage 128 chipsets: ATI Rage 128 RE (PCI), ATI Rage 128 RF (AGP), ATI Rage 128 RG (AGP), ATI Rage 128 RK (PCI), ATI Rage 128 RL (AGP), ATI Rage 128 Pro PD (PCI), ATI Rage 128 Pro PF (AGP), ATI Rage 128 Mobility LE (PCI), ATI Rage 128 Mobility LF (AGP), ATI Rage 128 Mobility MF (AGP), ATI Rage 128 Mobility ML (AGP) (II) RADEON: Driver for ATI Radeon chipsets: ATI Radeon QD (AGP), ATI Radeon QE (AGP), ATI Radeon QF (AGP), ATI Radeon QG (AGP), ATI Radeon VE (AGP) (--) Chipset ATI Rage 128 RF (AGP) found (II) Loading /usr/X11R6/lib/modules/libvgahw.a (II) Module vgahw: vendor="The XFree86 Project" compiled for 4.1.0, module version = 0.1.0 (II) R128(0): PCI bus 1 card 5 func 0 (**) R128(0): Depth 16, (--) framebuffer bpp 16 (II) R128(0): Pixel depth = 16 bits stored in 2 bytes (16 bpp pixmaps) (==) R128(0): Default visual is TrueColor (==) R128(0): RGB weight 565 (II) R128(0): Using 6 bits per RGB (8 bit DAC) Here ist the XF86Config part for my card: Section "Device" BoardName "Rage 128 RF" BusID "1:5:0" Driver "r128" Identifier "Device[0]" Screen 0 VendorName "ATI" EndSection -- MFG Gernot |
| Posted: 06 Feb 2004 11:05 PM PST Jake, Is there any way to upgrade compiler and libc support on older distros? - Steve Jake Thompson wrote: |
| Posted: 05 Feb 2004 09:51 AM PST "ant" <microstrain.NOSPAM.com> wrote in message news:HovUb.375$usenetserver.com... if make I've You would be best off with 1 power supply for each motherboard. Then each space between motherboards is cooled by one power supply's fan. The other issue is how to install hard disks. They shouldnt sit on the motherboard, so you need to fabricate brackets for them. been Can't you buy these things ? |
| You are subscribed to email updates from TextNData Forums - Linux To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
