[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

can't save Excel 4 workbook in Excel 2010...

I have a file in a network location that I could update and use in Excel 2007 but now that I'm using 2010 it won't let me. First it wouldn't even let me open it and I've followed the trust center changes to allow it to open, but it won't let me save it.

There are various file types in the 'file block settings' that don't have the option to check the 'save' box. How can I enable the save option on these other ones so I can open and save any type of file?
0
willlandymore
Asked:
willlandymore
  • 4
  • 2
1 Solution
 
Arno KosterCommented:
you can open the excel 4 workbook and a new excel 2010 workbook and manually copy all worksheets and VBA code pages.
0
 
willlandymoreAuthor Commented:
This is a shared file, so what happens when I copy and save it as a 2010 doc for them? Does everyone then have to install the compatibility pack to open it again?
0
 
willlandymoreAuthor Commented:
I would have thought that there must be some way to adjust the registry so that you can get the 'save' box for those other types of workbooks and then check it....
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
willlandymoreAuthor Commented:
Also, when I try to save it it says that it is a 97-2003 Worksheet, but I have that enabled in the file block settings to be able to open and save it. Then it also says, to save these types of files disable the registry setting and gives a KB number, but there is no registry setting in the article.

Does anyone know how I can kill this thing in the registry?
0
 
Arno KosterCommented:
according to the dutch knowledge base article on this matter, there are two options :

you can put  the excel 4 file in a 'trusted location' folder / assign the 'trusted location' status to the network share where the file resides .

you can download some template file / a cusomization tool which are supposed to help you setting the correct registry values

http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=64b837b6-0aa0-4c07-bc34-bec3990a7956


0
 
willlandymoreAuthor Commented:
yeah, I already went through the registry and it's just another way of changing what's in the trust center. I also add the network location as trusted and that didn't work, and when I saved it in a desktop folder and added that it still failed.

Uninstalling 2010 now and putting 2007 back on. I understand the whole 'beef up security' thing, but to remove things and make it impossible for the savvy users to configure them is silly.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now