Hi,
We have a folder that contains our ISO procedures within Excel. For some reason when some people open it theres a error message saying "File Error: Data may have been lost" ...and the pictures with hyperlinks are not there on any of the spreadsheets. This doesnt happen on everyones machine, but on the people that need it, it does.
Any ideas? I thought maybe this was a security patch that was installed but I dont know.....?????
Thanks in advance
Emma
.Let's start with this for more info:
Is the URL icon there but blank? (Maybe an X in the middle of the box?) If it's there, do the following:
Right-click on the URL
2. Select Hyperlink from the menu that appears
3. Is Remove Hyperlink box checked or unchecked?
This is a setting that is machine-specific. Post the answer as a comment and we'll take the next step if necessary
Is this in a network environment? Also is it possible the orginal file was converted from Excel 5.0 for use in Excel 2000?
What I would try is copy the prime file on the server on to a floppy disc (or thumb drive, etc) and open the copied file on one of the machines that exibit the problem. I still think a [save as] or setting on the local machine is the root of the problem. The message "File Error: Data may have been lost" indicates the embedded file change history in Excel is aware of a change/parameter problem or incompatibility.
Also, what version of Excel is on the machines that exibit the problem? Office or Excel 2000 should have Excel 9.0 (there is at least an SR1 update)
OK select where on the spreadsheet you want the hyperlink to be, then from the toolbar click:
Insert
Hyperlink
Use the existing file button on the left and browse for the file on the server. See if the "inserted links" button shows the original file location. Insert the hyperlink and try it.
[Quote comment] "All that happens when I create a hyperlink its just the shortcuts writing not pictures etc, but i cant even click on this to be able to go to that page"
Are you trying to say that the hyperlink you create appears as just typed text and not a highlighted link that when clicked on opens the path file or url?
Open a new excel spreadsheet and create a hyperlink in any cel. Copy & Paste the following URL as the path
http://www.fixya.com/
Save the spreadsheet...what happens to the copied and pasted url? Is it a working hyperlink?
×
The images may be in a folder that is not accessible by everyone on the network, or appears to be in a different location depending on what computer you are viewing the spreadsheet from.
make sure that the images are in the same folder as the spreadsheet, ammending any references to them as appropriate. do not reference them by their full path, ie; 'C:\Documents\photos\image1.jpeg',as the computer opening the spreadsheet will look on its own hardrive, instead just reference them by their filename, ie; 'image1.jpeg'.
Alternatively store the images on a shared network drive that has the same address on any computer on the network.
Obviously, use your actual filenames.
•
The easiest way to think of an iso file is more like a "zip" or "cab" file,
only without the compression.
An iso file contains the image of a disk. That means it contains all the files
and folders that were on that disk, much like a zip or cab file contains a
collection of files and folders. The real difference is that an iso is a
byte-for-byte copy of the low-level data actually stored on a disk.
There's nothing about the iso format that actually knows about files,
folders or formats. It's just the raw data from the disk. Now, naturally
that raw data, if interpreted correctly, may know about files, folders
and format. But, like a disk, the operating system has to look, see what format
was used (things like FAT32, NTFS and the like), and interpret the contents of
the iso file as if it were reading the raw data from an actual disk.
298 views
Usually answered in minutes!
Hi thanks for getting back to me guys.
This issue doesnt happen with everyone, I can open the same spreadsheet on another machine and it opens up fine with the pictures/hyperlinks. When opened there isnt any recolection of there being anything there. Its just completely blank. This was working fine before christmas as that was the last time things were updated.......
This is on a network (server). I dont think thats possible no, as the only people can edit this do so within work using the same version.
I copied one of the documents onto a memory stick to see if I could open this on another machine and it worked fine, when running it on mine the error was occuring. I took a look at what version it is and your correct it is 9.0..... im baffled......
All that happens when I create a hyperlink its just the shortcuts writing not pictures etc, but i cant even click on this to be able to go to that page.
yes thats correct jimcedar....
×