Sharepoint Spreadsheets not syncing

%3CLINGO-SUB%20id%3D%22lingo-sub-1015534%22%20slang%3D%22en-US%22%3ESharepoint%20Spreadsheets%20not%20syncing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1015534%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20a%20master%20spreadsheet%20for%20all%20pricing%20on%20parts.%20This%20includes%20list%20prices%2C%20multipliers%2C%20etc.%20They%20can%20change%20often%2C%20and%20so%20I%20tie%20all%20of%20my%20pricing%20spreadsheets%20for%20routine%20jobs%20to%20this%20master%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20we%20change%20out%20a%20quantity%20of%2024%20of%20the%20same%20part%20twice%20a%20year.%20In%20the%20columns%20for%20list%20price%20and%20multiplier%2C%20I%20set%20them%20to%20equal%20the%20values%20in%20the%20master%20spreadsheet.%20All%20of%20the%20spreadsheets%20are%20stored%20in%20the%20company%20SharePoint%2C%20which%20I%20have%20synced%20with%20my%20laptop%2C%20and%20am%20accessing%20via%20the%20desktop%20Excel%20application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20set%20the%20formulas%2C%20they%20work%2C%20and%20the%20data%20updates.%20However%2C%20when%20I%20close%20out%20excel%20and%20open%20it%20back%20up%2C%20I%20get%20the%20following%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Sorry%2C%20we%20couldn't%20open%20%3CA%20href%3D%22https%3A%2F%2Fblejwas.sharepoint.com%2FUsers%2Ffarrelltamke%2FBlejwas%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblejwas.sharepoint.com%2FUsers%2Ffarrelltamke%2FBlejwas%3C%2FA%3E%20Associates%2C%20Inc%2FBlejwas%20-%20Blejwas%20Sharepoint%2FSales%20Assets%2FPricing%2FPricing%20Books%2F%5BMASTER%20PRICING.xlsx%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20exact%20file%20path%20to%20the%20aforementioned%20spreadsheet.%20IS%20what%20I'm%20intending%20to%20do%20just%20not%20possible%2C%20or%20is%20this%20an%20issue%20of%20granting%20permissions%20for%20the%20master%20pricing%20spreadsheet%3F%20Again%2C%20all%20of%20the%20individual%20job%20spreadsheets%20exist%20in%20the%20SharePoint%20as%20well%2C%20I%20just%20use%20the%20desktop%20application%20to%20make%20edits%20faster.%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1015534%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I use a master spreadsheet for all pricing on parts. This includes list prices, multipliers, etc. They can change often, and so I tie all of my pricing spreadsheets for routine jobs to this master sheet.

 

For example, we change out a quantity of 24 of the same part twice a year. In the columns for list price and multiplier, I set them to equal the values in the master spreadsheet. All of the spreadsheets are stored in the company SharePoint, which I have synced with my laptop, and am accessing via the desktop Excel application.

 

When I set the formulas, they work, and the data updates. However, when I close out excel and open it back up, I get the following error:

 

"Sorry, we couldn't open https://blejwas.sharepoint.com/Users/farrelltamke/Blejwas Associates, Inc/Blejwas - Blejwas Sharepoint/Sales Assets/Pricing/Pricing Books/[MASTER PRICING.xlsx]

 

This is the exact file path to the aforementioned spreadsheet. IS what I'm intending to do just not possible, or is this an issue of granting permissions for the master pricing spreadsheet? Again, all of the individual job spreadsheets exist in the SharePoint as well, I just use the desktop application to make edits faster. Thank you in advance!

1 Reply
Highlighted

@farrelltamkeHave you tried clearing Office File Cache in %localappdata%\Microsoft\Office\16.0\OfficeFileCache ?