Upgrade from Excel 2003 to 2007

L

Linda T

Where I work they are going to be ugrading Office 2003 to 2007
version. I am an Excel 2003 Power User you could say. I have many
drop down menus that I have customized and tons of macros and macro
buttons and these took years to develop over time. I am able to
"perform my magic" as my boss would say and I would take complex
reports and manipulate them how they want and in a minimal amount of
time. I was called the Data Diva here.

I understand that Excel 2007 won't allow those functions for me. I
have read about the addins to give back the class view toolbar and I
was told I would not be allowed to purchase it. Is there any work
around to this? My work production will drop significantly. Nobody
where I work really understands because they don't need all of the
functions I do. That is why I do this for them.

Is there a VB code that I can copy and put in as my own add-in to
create the classic custom toolbar myself? I have read that you can
save your toolbars in 2003 and save them as an add-in and when you
open it in 2007 it brings back the classic toolbar. I don't know if
that works because we haven't been upgraded yet.

This will greatly affect my work since 85% of my work is in Excel.

Please help!!
Thanks
 
P

Peo Sjoblom

If you are a power user you will feel like you are stuck in a Kafka like
environment where everything is hidden beyond imagination :)

I still use 2003 95% of the time (I have them both installed) and I was a
beta tester etc. You can make the change less hard by putting a lot of stuff
on the QOT also known as the Quick Access Toolbar. Of course there are some
improvements as well but overall it is not an upgrade IMHO

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top