Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How can I keep files from being redirected in Win 7

08 Jan 2014   #1
87syncro

Windows 7 64 bit
 
 
How can I keep files from being redirected in Win 7

Have a Dell TC3500 from a business. Win 7 pro plus was/is loaded along with Visual Studio 2008 and VS 2010, SQL Server 2008. I loaded Office 2010 pro plus yesterday (activation has been done and is OK).

I am trying to move copies of files from an older Dell WS running XP. All files are on an external HD. Have moved one folder (only) containing mostly Excel 2000 files. No trouble/errors when moving to Win 7 "Documents/My documents/Samples".

One file contains cells that "receive" data from other Excel files that are loaded daily. Just a simple way of saving/displaying/tracking yearly data.

This file opens OK in Excel 2010 but the "linking cells formula" now have "directories added to them". I think the files are being redirected and I prefer them to be in the "Documents/My Documents/Samples" folder. Helps make the formula more "compact" along with being easier to keep files/data in order.

These files have been working without abnormal problems for several years. I am new to Win 7 (have been using XP Pro for years) and would like Win 7 to allow me to keep using the files without major changes.

Any way to get this done without becoming a "software guru"?

Any and all help will be greatly appreciated.


My System SpecsSystem Spec
.
08 Jan 2014   #2
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Nope - you must become a software guru!

For staters, read this https://support.microsoft.com/kb/328440

I no longer use Excel, so I cannot check where the setting might be, but what you're looking for is in this area:
Quote   Quote: Originally Posted by Microsoft Support
Relative vs. absolute links

Links to external workbooks are created in a relative manner whenever possible. This means that the full path to the source data file is not recorded, but rather the portion of the path as it relates to the linked workbook. With this method, you can move the workbooks without breaking the links between them.

The links remain intact, however, only if the workbooks remain in the same location relative to each other. For example, if the linked file is C:\Mydir\Linked.xls and the source data file is C:\Mydir\Files\Source.xls, you can move the files to the D drive as long as the source file is still located in a subfolder called "files".

Relative links may cause problems if you move the linked file to different computers and the source is in a central location.
What were the original locations relative to each other?
My System SpecsSystem Spec
08 Jan 2014   #3
Kari

Microsoft Community Contributor Award Recipient

 

Slartybarts post pretty much summarizes it.

The way Excel handles links to external workbooks is why I keep my Excel files on an external drive. I can connect it to any Windows PC and all referrals to external workbooks and sheets always work.

Another good way to work with Excel is to use SkyDrive as storage; Excel like all Microsoft Office products works well with SkyDrive.

A practical way to combine both is to use external storage and create the same folder structure on SkyDrive, backing up the external drive's Excel folders there.

Kari
My System SpecsSystem Spec
.

09 Jan 2014   #4
87syncro

Windows 7 64 bit
 
 
Appreciate your replies

Slartybart,

Don't think I can ever become a software "guru"!! But your suggested "reading" and further reading of Win 7 help files gives me a better understanding of 7 file structure. It will take time and more reading to develop a "full appreciation" of Win 7.

Kari,

Never thought about trying the external HD as a file "base". Think I attempted that with XP. As well as I remember, I had a problem with that approach using XP. Could a USB flash memory also be used for an external directory?

I have the files updating as they should for now (at least it worked this morning). I did the "save as" function and selected 2003-2007 workbook option for all files.

Again, really appreciate your responses. Helped me get me "moving in the right direction".
My System SpecsSystem Spec
09 Jan 2014   #5
Kari

Microsoft Community Contributor Award Recipient

 

I cannot see any issues using in using external storage, impossible to say why you had issues with XP and Excel.

Any external storage is fine, also a USB flash. Just keep in your mind a USB flash memory is more vulnerable than an external HDD; be sure you backup your data.
My System SpecsSystem Spec
Reply

 How can I keep files from being redirected in Win 7




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Cannot save excel files in a redirected folder unles I use save as
The computer involved is using Windows 7 Pro 64bit and Office Professional Plus 2010. I am having a problem I cannot find a solution to. I have one user at a clients location that has recently stopped being able to save excel files in their my documents. The my docs is being redirected to a...
Network & Sharing
My Home Page Keeps Getting Redirected
I'm using Firefox ver 4.0.1 and my home page is set to "blank". The problem started today. Whenever I click on "Home" on the toolbar I get redirected to a site called "Global Classified--Pasar". I checked my options settings and it is still listed as "blank" for my home page. Any ideas of how to...
Browsers & Mail
SB Audigy SE - No bass redirected
Hi everybody! I am using the Win7 build 7000, and the driver for my SB Audigy SE was installed from windows update (basic driver). I configured to work on 5.1 and tested, it was OK. But the same problem that I faced on Vista happened here: the bass signal is not being redirected to my subwoofer....
Sound & Audio
Getting redirected from websites...
Hello everyone last week I started getting redirected from websites on my laptop but I decided to ignore the problem but tonight it just got worst I canīt open any website at first it starts loading then it redirects me to gostats.com. I google it and it came back as a virus so I decided to run a...
System Security
Apple Quicktime URL redirected??
I was looking to download the latest Apple Quicktime player for a friend of mine yesterday, and i noticed Firefox red-flagged the site. What do you think from the screen shot I attached here.:eek: Now if you try to download Quicktime now...no problems. Very strange indeed.
Browsers & Mail
Redirected here.
http://www.sevenforums.com/crashes-debugging/52241-random-bizarre-freezes.html All my info is already there. usamsa (hope I spelled that right) told me I ought to come over here after he gave me some advice and it didn't work out as planned. I'm.. considerably more concerned now, especially...
System Security


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Đ Designer Media Ltd

All times are GMT -5. The time now is 21:35.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App