Prev: Excel2007 Excel Help "This Page is Unavailable"
Next: how i fix a corupted excel worksheet.
From: zeetoe04 on 28 Apr 2010 11:54
Good afternoon,

I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.

We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no formatting
again!

As mentioned, the file had a ton of broken links that were removed as
we thought that was the issue but that didn't help.

I've found that if I save it as a xlsx file, it will keep the
formatting (so far) but we have people with the 2003 version of excel
that need to use the file as well.

Any help or guidance would be greatly appreciated.

Thanks,
Krysten
From: Jim Cone on 28 Apr 2010 12:26
Maybe...

Similar problem...
http://lounge.windowssecrets.com/index.php?showtopic=774151

and the solution was...
http://excelusergroup.org/media/p/4861.aspx
(free - Formats and Styles Excel add-in - no registration)
--
Jim Cone
Portland, Oregon USA



"zeetoe04" <kmzito(a)gmail.com>
wrote in message news:148afcd8-49c3-4d52-a0bd-fd29838f781f(a)k33g2000yqc.googlegroups.com...
Good afternoon,

I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.

We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no formatting
again!

As mentioned, the file had a ton of broken links that were removed as
we thought that was the issue but that didn't help.

I've found that if I save it as a xlsx file, it will keep the
formatting (so far) but we have people with the 2003 version of excel
that need to use the file as well.

Any help or guidance would be greatly appreciated.

Thanks,
Krysten
From: zeetoe04 on 28 Apr 2010 14:01
The application does not work. It will remove everything but when I go
to save the file, it tells me that Microsoft Office has an error and
needs to close Excel.


On Apr 28, 12:26 pm, "Jim Cone" <james.cone...(a)comcast.netXXX> wrote:
> Maybe...
>
> Similar problem...http://lounge.windowssecrets.com/index.php?showtopic=774151
>
> and the solution was...http://excelusergroup.org/media/p/4861.aspx
> (free - Formats and Styles Excel add-in -  no registration)
> --
> Jim Cone
> Portland, Oregon  USA
>
> "zeetoe04" <kmz...(a)gmail.com>
> wrote in messagenews:148afcd8-49c3-4d52-a0bd-fd29838f781f(a)k33g2000yqc.googlegroups.com...
> Good afternoon,
>
> I've spent a lot of time googling but all I really came up with is
> that it may be due to links (which I have deleted) so hopefully
> someone out there will have an answer.
>
> We have a very large workbook that has been used since before 2005
> that we have never had a problem with. Two months ago, we started
> using Excel 2007 but had no issues. In about mid-April when opening
> the file, all of the formatting is gone! So we assumed someone saved
> it as the wrong file so we copied an older version of the file and
> reformatted the entire thing. Saved it and reopened and no formatting
> again!
>
> As mentioned, the file had a ton of broken links that were removed as
> we thought that was the issue but that didn't help.
>
> I've found that if I save it as a xlsx file, it will keep the
> formatting (so far) but we have people with the 2003 version of excel
> that need to use the file as well.
>
> Any help or guidance would be greatly appreciated.
>
> Thanks,
> Krysten

From: zeetoe04 on 28 Apr 2010 22:08
Unfortunately I cannot forward it to you. If I disable the add-on, it
would save. We'll see tomorrow if it holds the formatting.
From: zeetoe04 on 1 May 2010 22:40
On Apr 28, 10:08 pm, zeetoe04 <kmz...(a)gmail.com> wrote:
> Unfortunately I cannot forward it to you. If I disable the add-on, it
> would save. We'll see tomorrow if it holds theformatting.

So far so good. Thanks for the help.
 |  Next  |  Last
Pages: 1 2
Prev: Excel2007 Excel Help "This Page is Unavailable"
Next: how i fix a corupted excel worksheet.