Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

snakedoctor

macrumors member
Original poster
Feb 1, 2008
59
0
If open any spreadsheet from a Excel 2003 or 2007 from windows that has a URL (www.macrumors.com) in a cell it will error during the opening and tell me its corrupt or whatever, and then open.

When I exit the file it wants me to save...I have not for fear of it messing the file up.

Anyone else see this?????
 
If open any spreadsheet from a Excel 2003 or 2007 from windows that has a URL (www.macrumors.com) in a cell it will error during the opening and tell me its corrupt or whatever, and then open.

When I exit the file it wants me to save...I have not for fear of it messing the file up.

Anyone else see this?????

The only issue {besides some crashes related possibly to graphics update} that I found for Excel with the update was:

All hyperlinks were removed. This caused Excel to report a Data Loss message to me whenever I opened a workbook. If you save the workbook it will save without the Hyperlinks {in my case}. Only solution I found was basically, I had to rebuild all my Hyperlinks, which was very tedious...

I reported this to the Mactopia forums, and someone from Microsoft is looking into it. The issue is not hyperlinks not working, but rather, with the update, all hyperlinks disappeared. Specifically for me, any workbooks with hyperlinks in them, that were created in Office 2k3, 2k7 obviously on PC's are my problem.

Anything I created in 2008 and opened after update, seem to be ok so far. Still testing, as I also had to remove my Leopard Graphics Update 1.0 to address {hopefully} an issue where my MBP would lock up completly due to some actions done with Excel.

So far after removing the graphics update, I have not had an issue with crashes or lock-ups, but I am still testing.
 
Thanks, that is basically my issue as well. If there is no URL/hyperlink in the spreadsheet it opens fine with the hyperlinks I get....

"File error: data may have been lost."

I dont have the problem with the graphics update but I only have a SR Macbook.
 
missing hyperlinks

I have the same problem. Any spreadsheets I open that are sent to me that have any hyperlinks in them, 2008 strips them all out and I get the data loss error. :(

The only issue {besides some crashes related possibly to graphics update} that I found for Excel with the update was:

All hyperlinks were removed. This caused Excel to report a Data Loss message to me whenever I opened a workbook. If you save the workbook it will save without the Hyperlinks {in my case}. Only solution I found was basically, I had to rebuild all my Hyperlinks, which was very tedious...

I reported this to the Mactopia forums, and someone from Microsoft is looking into it. The issue is not hyperlinks not working, but rather, with the update, all hyperlinks disappeared. Specifically for me, any workbooks with hyperlinks in them, that were created in Office 2k3, 2k7 obviously on PC's are my problem.

Anything I created in 2008 and opened after update, seem to be ok so far. Still testing, as I also had to remove my Leopard Graphics Update 1.0 to address {hopefully} an issue where my MBP would lock up completly due to some actions done with Excel.

So far after removing the graphics update, I have not had an issue with crashes or lock-ups, but I am still testing.
 
I have the same problem. Any spreadsheets I open that are sent to me that have any hyperlinks in them, 2008 strips them all out and I get the data loss error. :(

Unfortunately I have not seen anything from MacBU etc., addressing this nor how to fix it.
 
I noticed that if I save the doc in xlsx format, the hyperlinks stay. If I save in xls format, the hyperlinks go away.

Anyone confirm this?
 
worksheets bug?

I don't know if I just did something foolish, or if there is a big bug here.

I made a spreadsheet with many pages. I saved it (I believe) as a .xls (2004 compatible) file.

and poof! all my sheets are gone except for one.

A few things may have happened. 1) excel is just a mess and doesn't save multiple sheets in .xls format. 2) I started the file by opening a text file, and kept it saved as text. If this is the case, the old error message "some features may be lost", or whatever it used to say seems to be missing.

I think option 2 is sorta unlikely because I do have the .xls extension on my file, and that most likely got there by "save as"

ideas?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.