All my files are starting out with the filename of file:/// except files from Program files and files directly under the C:/ drive. Please help.

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Probably stored on one drive or cloud servers, this link might help you to understand the formatting of file paths.

 
Upvote 0
Probably stored on one drive or cloud servers, this link might help you to understand the formatting of file paths.

Thank you for the response. Any idea how I can fix this troubling issue?
 
Upvote 0
Fix what? What exactly is the issue?
There can be multiple different way to refer to a file path. It is not the case that one is correct and one is not. They both are, it is just looking at it from a different perspective.

What is it that you are actually trying to do here?
 
Upvote 0
I apologize for my terse response in post #4, but as @Joe4 points out and the link which I provided spells out, file/directory paths might begin with a letter designation [A-Z] or file separator symbols (\\\) and still get you to the files or directory you want to go to. It depends on where the files are located . For the most part, files store on your desk top device hard drive will use a logical drive letter (Usually C - D), at initial set up. The A and B drives are normally for auxiliary drives for external disk storage, and other letter designated drives for things like graphics uploads, etc. Since servers use names, they can be addressed with or without a leading alpha letter designation, as apparently many of your file paths do. It is nothing to be alarmed about. It is simply a method of routing so that when you call for the file or directory, it will go to the correct server. That is all explained in the link that was provided. I suggest you read the entire article, even if at this point you do not understand some of it, it will be something you can refer back to in the future as you develop a better understanding of how files are managed within a system.
Regards, JLG
 
Upvote 0

Forum statistics

Threads
1,223,631
Messages
6,173,465
Members
452,516
Latest member
archcalx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top